Re: Simplest way to set a date as the first of the current month.

On 06/07/2008, at 12:35 PM, Gene Burns wrote:

I don't have access to a system right now, but will this work?

d today s d

today = %date();
%subdt(today: *days) = 1;

I initially wondered that too but the documentation says %subdt EXTRACTS a value from a date which is why I suggested a data structure to set the day component. That is different from %subst which can be used on either side of an expression. While not as explicit as the documentation for %DAYS, %MONTHS, and %YEARS, %SUBDT also can only be used on the right-hand side of an expression. Trying your code will result in RNF0955 - Item not valid on left-hand side of an EVAL operation.

Note that IF this worked the name of the variable "today" would be poorly chosen because the resulting date would no longer BE today (except for one day a month).

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------