WEBVTT

00:00:02.066 --> 00:00:08.299
Welcome to this ACE Reports video,
Adding Dynamic Dates.

00:00:08.300 --> 00:00:14.766
This video will demonstrate how to
Add Dynamic Dates for Reports.

00:00:14.766 --> 00:00:19.266
Query filters refine the search
parameters of a report.

00:00:19.266 --> 00:00:24.566
The query filter operand defines the
filter object value and how the

00:00:24.566 --> 00:00:27.166
value is selected.

00:00:27.166 --> 00:00:32.099
Normally, the values of date filter
objects are set using a constant

00:00:32.100 --> 00:00:35.666
value or user prompt value.

00:00:35.666 --> 00:00:41.632
However, these methods are inefficient
for recurring scheduled reports where

00:00:41.633 --> 00:00:48.366
the date range needs to update for each
instance such as a monthly report.

00:00:48.366 --> 00:00:54.266
For these reports, a dynamic date range
that automatically adjusts based on the

00:00:54.266 --> 00:00:58.666
report run date is available.

00:00:58.666 --> 00:01:02.699
Open a report that contains
a date range.

00:01:02.700 --> 00:01:07.300
Select the Design mode.

00:01:07.300 --> 00:01:17.100
In Design mode, in the Query tab,
select the Edit icon.

00:01:17.100 --> 00:01:19.900
The Query Panel displays.

00:01:19.900 --> 00:01:27.133
In the Query Filters pane, in the desired
date object, select Between as the operator

00:01:27.133 --> 00:01:30.366
to create a dynamic filter.

00:01:30.366 --> 00:01:36.932
In the first date object field, select
the Click to Define filter type icon,

00:01:36.933 --> 00:01:41.899
and select Object from this query.

00:01:41.900 --> 00:01:49.266
In the Objects dialog box, if required,
expand the Date Objects folder.

00:01:49.266 --> 00:01:51.699
Select a date object.

00:01:51.700 --> 00:01:56.166
Select the OK button.

00:01:56.166 --> 00:02:00.666
Repeat these last steps for the
second date field.

00:02:00.666 --> 00:02:08.399
Select the Apply and Close button.

00:02:08.400 --> 00:02:12.966
Save the report.

00:02:12.966 --> 00:02:16.566
Refresh the report.

00:02:16.566 --> 00:02:22.366
This concludes our demonstration of how
to Add Dynamic Dates for Reports.

00:02:22.366 --> 00:02:30.099
If you have any questions,
email acetraining@cbp.dhs.gov.