How to get current date in DDS
is it possible to get the current date (CUR_DATE()). how?
R SERFMT PFILE(BLUSOC)
K SERSN
S SERIND COMP(NE 0)
SEROTD VALUES(0 99999999)
S SEROTD COMP(GE CURDAT())
Software/Hardware used:
A/S400
Software/Hardware used:
A/S400
ASKED:
April 9, 2010 1:25 AM
UPDATED:
April 9, 2010 7:37 PM
RELATED QUESTIONS
- How can I set the default to be on current date when form loads
- Is there a quick way of running a query to select records based on" current sysdate - 1" i.e yesterday.
- RPG date retrieval
- Plus signs in fields when using a date from a file compared to the month and year function
- What is and Why am I getting a MCH1202 error message on a field compare statement?
Answer Wiki:
I have not seen it done. We get around a situation like this by using the OPNQRYF command. get date as a system variable and use that.
Similar to this.
OPNQRYF FILE((AFP)) FORMAT(*LIBL/AFP01) +
QRYSLT('(AFDATE *GE ' || &DTYMD ||
*AND AFDATE *LE ' || &DT2YMD || ')
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
