To return the last date of the month in the given date parameter. That is: when the type received is date, it returns a date value, and when the type received is datetime, it returns a datetime.
Syntax
EoM(date-expression | datetime-expression)
Type Returned:
Date|DateTime
Examples
Supposing the Language is set to English:
EoM(CToD('01/01/08'))
Result: 01/31/08
EoM(CToD('02/05/91'))
Result: 02/28/91
EoM(Now())
Result: 01/31/98 10:30:12 if Now() = 01/10/98 10:30:12
Date1 = EoM(Now())
Result: 01/31/98 if Now() = 01/10/98 10:30:12 and Date1 is a date type attribute
Scope
Objects Procedure object, Transaction object, Web Panel object
See also
TimeZone Support - General Considerations
EndOfMonth Method
|