Expression: Date List Functions

These functions help you manipulate lists of dates.

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])