Skip to main content

Posts

Showing posts from September, 2018

Special Date Values for Filter Criteria

If you do a tabular report, you have the option of limiting it to the top 5.  You do this in the custom filter portion of the report design. Here's all the special date filters -- copied from Online Help Special Date Values for Filter Criteria Available in:  All  Editions Use the following special date values when defining filter criteria using dates. If you choose a date field (for example, Create Date,  Last Update Date ) as a filter criteria, the value can be a date in the format allowed by your Locale setting or any of the following special values: Special Date Value Range YESTERDAY Starts at 12:00:00 a.m. on the day before the current day and continues for 24 hours. TODAY Starts at 12:00:00 a.m. on the current day and continues for 24 hours. TOMORROW Starts at 12:00:00 a.m. on the day after the current day and continues for 24 hours. LAST WEEK Starts at 12:00:00 a.m. on the first day of the week before the current week and continues for seven days. For En