Filter a Range Relative to Now
Overview
NOW and UTCNOW become point-in-time values. NOW and UTCNOW are computed once for the entire report right before the report runs. NOW and UTCNOW refer to the same point in time. NOW and UTCNOW support offsets by day, hour, minute, or second.
NOW is resolved relative to the time zone of the user running the report. This time zone can also be overridden by the report.
Note
See TODAY for filtering related to today.
For example:
- <NOW 4.12:00:00> is current time in the report’s local time zone offset by four days, 12 hours.
- <UTCNOW -6:00> is current time in UTC offset by negative six hours.
When you select the Now filter option on a date column, Data Access Studio will prompt you with the following form:
Filtering with Time on Date/Time Columns
Since DAS filtering uses the common time separator (:) as the AND operator, we must include date ranges that include time inside a DATE token.
<DATE mm/dd/yyyy hh:mm:ss>
This DATE token takes a Date/Time string in Culture Invariant format (that is, U.S.-biased month/day/year hour:minute:second format).
Operands such as >, >=, <, <= can be used with the DATE token to indicate greater than, greater than or equal to, less than, less than or equal to.
Filtering a Single Date/Time
<DATE 02/06/2006 12:16:09>
Normal:
Editing:
Filtering a Date/Time by Range
>=<DATE 02/01/2006 06:00:00>:<=<DATE 02/28/2006 18:00:00>
Normal:
Editing:
Note
The DATE token is only visible while editing. After exiting the field, the format of the filter will match the user’s preferences.
Date Ranges can only be applied to single columns.
Editing a Date Filter
If the ellipsis button is clicked inside a Date/Time field, a date visual assist will be displayed and allow for a date or date range to be selected. You can click a start date and drag the mouse to an end date in order to select a range of dates.
Set the start time and end time for a particular date or date range below the calendar.
Editing a Date Range Filter
Select the funnel icon in a Date/Time column to display the popup menu.
Select the Range option to open the Define filter range dialog.
Selecting values from the calendar visual assist and the range visual assist will generate the DATE token syntax automatically after OK is pressed.
Selecting the From and excluding or the Through and excluding options, excludes the selected date from the range.
Convert E1 Time to Standard Time Format
If an E1 time needs to be converted to a standard time format refer to the following article: