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.
October 5, 2009 11:15 AM
October 6, 2009 7:05 AM