Skip to content

Date list functions

These functions help you manipulate lists of dates.

FirstDate

Returns the first date in the list of dates.

Expression
FirstDate (date1, date2,...)

For example:

  • FirstDate([Date1], "20060101")
  • FirstDate([Date1], [Date2], [Date3])

Note

Dates can also be included as yyyymmdd.

LastDate

Returns the last date in the list of dates.

Expression
LastDate (date1, date2,...)

For example:

  • LastDate([Date1], "20060101")
  • LastDate([Date1], [Date2], [Date3])

Note

Dates can also be included as yyyymmdd.