Re: Re Last day of the next month

David Foxwell wrote:

Now, what about the FIRST day of the month?
... at the moment I have :

/Ugh
1stDay= %DATE ( '01' + %SUBST ( %CHAR ( MyDate ) : 3 ) : *EUR ); //
Format is DD.MM.YYYY.

/End-Ugh

Subtract the number of days in the month less one:

FirstDay = MyDate - %days(%subdt(MyDate : *d) - 1);

Your current code would only work if MyDate had datfmt *EUR; it would work for all date variables if you code %CHAR(MyDate:*EUR). But still, it's better to avoid messing with the formats at all, except where it's necessary due to having dates in character or numeric variables.