AS/400 query, when I have TODAY = current(date), then when
today - 1 month,
If the current date is Jan 1, 2013, will it be Dec 1, 2013 or Dec 1, 2012? I assume Dec 1, 2012, but want to be sure. Likewise, on Mar 1, 2013 current, it would give Feb 1, 2013, correct (again, I only really care if it is Feb 2013, not using day)
I don't care about the day, but intend to use month and year from this process (query in job scheduler to run on the first day of each month), to get activity occurring last month. Want to make sure there are no holes in my logic.
February 5, 2013 11:49 AM