Function group | Execute on client | Platform(s) |
---|---|---|
Date and Time | NO | All |
lday(datepart,date)
Returns the date of the last day of the year, month, week or quarter in which the specified date falls. datepart can be kYear, kQuarter, kMonth, or kWeek.
The period is specified using one of the following datepart constants: kYear, kQuarter, kMonth, kWeek.
Calculate lDate as lday(kWeek,#D)
# returns May 11 2003, assume #D is May 8, 2003
Calculate lDate as lday(kMonth,#D)
# returns May 31 2003, assume #D is May 8, 2003