First Day of the Month

slmaluwa

Hi
Say, DateX is a date variable holding some unknown date.

How do I find the first day and the last day of the month in that date variable?

TIA

Maluwa

kriki

datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));

DenSter

I believe the last day of the month is doing a date calculation with 'CM' as the dateformula. Not sure though, I'd have to verify that.

kine

First day of month is

FirstDayDate := CALCDATE('<-CM>',MyDate)l

And that's all..

kriki

kriki wrote:

datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));

Did see that also the last day of the month was needed:

datLastDayOfMonth := CALCDATE('<1M>',datFirstDayOfMonth) - 1;

kine

kriki wrote:

kriki wrote:

datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));

Did see that also the last day of the month was needed:

datLastDayOfMonth := CALCDATE('<1M>',datFirstDayOfMonth) - 1;

Or in generaly:

datLastDayOfMonth := CALCDATE('<CM>',datMyDate);

8)

kriki

kine wrote:

kriki wrote:

kriki wrote:

datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));

Did see that also the last day of the month was needed:

datLastDayOfMonth := CALCDATE('<1M>',datFirstDayOfMonth) - 1;

Or in generaly:

datLastDayOfMonth := CALCDATE('<CM>',datMyDate);

8)

And with this we are proving there are, most of time, multiple good solutions for the same problem. 8)

garak

and the last solution, but to many code lines, go over the Day record

kopav

Please pay attention to use '<CM>', not just 'CM'. 'CM' will throw an error if language is not English))

JJMc

Or just DMY2Date(1);