EoM function

Official Content
This documentation is valid for:

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





Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.