EoM function

Returns the last date of the month in the given date parameter, i.e. 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

Scope

Objects: Procedure, Transaction, Web Panel, Panel, Data Provider
Generators: .NET, .NET Framework, Java, Apple, Android, Angular

Samples

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

See Also

TimeZone Support - General Considerations
EndOfMonth method