lday()

Function group Execute on client Platform(s)
Date and Time NO All

Syntax

lday(datepart,date)

Description

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.

Example

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