IncrementDate

The IncrementDate Function

Increment a date by a certain number of days, months or years.   Command structure: «IncrementDate(DateOfBirth,25, “y”)» The above will add 25 years to the value in the data element ‘DateOfBirth’.   Some simple examples: Tomorrow: «IncrementDate(Today(),1,”d”)» i.e. add 1 day to today’s date. Yesterday: «IncrementDate(Today(),-1,”d”)» i.e. subtract 1 day

Read More »