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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!