Date Adjustment

The date adjustment feature allows date values to be dynamically increased or decreased relative to the current date. The following values are permitted, where X is any integer:

Year-X subtracts X years from the current date; +X adds X years to the current date.

Month-X subtracts X months from the current date; +X adds X months to the current date. If X is not a valid month (e.g., 34), the month is set to 12.

Tag-X subtracts X days from the current date; +X adds X days to the current date.

If `Tag` is 1, the first day of the month is used. If you set the day to 0, the last day of the previous month is used. If the value for "Month" is +1 and the value for "Day" is 0, the last day of the current month would be determined. Hours, minutes, and seconds can be adjusted relative to the current time when using the "Date and Time" or "Time" control type. Specifying an unsigned integer sets the hour (or minute or second) to the corresponding value. If you want to retrieve all records within a specific time period, you must define a filter using an "AND" operator. For example, here is the filter expression for finding all appointments for today:

Start Date < System Value for Today (with time)
Date adjustment: Day + 1, Hour 0, Minute 0, Second 0
AND
End Date > System Value: Today (with time)
Date adjustment: Hour 0, Minute 0, Second 0