Eomonth

I use CR 13,
Is there an alternative function for the EOMonth -function ?

I cant find EOMonth in my program and i have to calculate de last dat of the Month after i have count also 30 days after a date in my database.

For example: DB-date = 24-04-2018
Dateadd (d,30, {DB-date}) gives me 24-05-2018.
And then i have to calculate to 31-05-2018 (last day of the month )or 01-06-2018 (First day of the next month).


Edited by kv41282 - 29 Apr 2018 at 7:28am

for current month here is one option:

dateserial(year(currentdate),month(currentdate)+1,1-1)