Date minus 1 month in January
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.
Thanks.
Software/Hardware used:
iseries
Software/Hardware used:
iseries
ASKED:
February 5, 2013 11:49 AM
RELATED QUESTIONS
- Date calculation incorrect in sql when +1 month entered
- Message Ids in Message File
- AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?
- Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
- Crystal Reports- displaying calculations for date range prior to date search parameter
Answer Wiki:
If you are using the function of munus 1 month, the date will be 12/01/12.
To see all answers submitted to the Answer Wiki: View Answer History.
Dec 1, 2012