Date adjustment

With date adjustments, date values can be dynamically increased or decreased in relation to the current date. The following values are allowed, where X corresponds to an arbitrary integer:

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

Month-X removes 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.

Day-X removes X days from the current date; +X adds X days to the current date.

If day has the value 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. With a value of +1 for month and a value of 0 for day, the last day of the current month would be determined. Hours, minutes and seconds can be adjusted in relation to the current time if the "Date and time" or "Time" control type is used. By entering an unsigned integer, the hour (or minute or second) is set to the corresponding value. If all data records in a certain period are to be determined, a filter with an AND link must be defined. So, for example, the filter expression to deliver all appointments for the current day should read as follows:

AppointmentStart < system value Today (with time)
Date adjustment: day + 1, hour 0, minute 0, second 0
AND
DateEnd > System value Today (with time)
Date adjustment: hour 0, minute 0, second 0