I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible?
I already tried with substracting 31 and 93 days but that is not full-proof because of the month february.
Software/Hardware used:
OS/400 V5R3M0
ASKED:
October 5, 2009 11:15 AM
UPDATED:
October 6, 2009 7:05 AM
Thanks Phil,
this is exactly what I needed in Query/400.
thanks very much,
Chris