Expression: Date List Functions

FirstDate

Returns the first date in the list of dates. Dates can also be included as yyyymmdd.

FirstDate (date1, date2,...)

FirstDate([Date1], "20060101")

FirstDate([Date1], [Date2], [Date3])

LastDate

Returns the last date in the list of dates. Dates can also be included as yyyymmdd.

LastDate (date1, date2,...)

LastDate([Date1], "20060101")

LastDate([Date1], [Date2], [Date3])

Returns the Nth date in the list of dates. For example:

Returns the earliest datetime from a list of datetimes. These values can be variables, fixed datetimes, or results of datetime expressions.

FirstDate([Registration DateTime], [First Order DateTime]) - returns the earliest of these two datetime variables.

Returns the latest datetime from a list of datetimes. These values can be variables, fixed datetimes or results of datetime expressions.

LastDateTime([Registration DateTime], [First Order DateTime]) - returns the latest of these two datetime variables.

Returns the Nth datetime specified by the number from a list of datetimes from earliest to latest. These values can be variables, fixed datetimes, or results of datetime expressions. If the number specified is negative then the Nth latest is returned.

NthDateTime(2,[Registration DateTime], [First Visit DateTime], [Cancellation DateTime]) - returns the second of these three datetime variables, once ordered from earliest to latest date.