Function for last date of a month ?

[make]

Hi Peggers,

iam still looking for a function or something else, wich can retrurn the last date of a month.
For example : the last date from January ist the 31.

Thanks for help !

make

 

[toby.Harman]

Enjoy!

function GetEOM return date
(input dt as date):

return ( (date(month(dt),28,year(dt)) + 4) -
day(date(month(dt),28,year(dt)) + 4)
).

end. /* GetEOM */

 

[Olivier_Desmars]

I usually take the 1st day of the next month and substract one day. It's a bit 'heavy' but always work.