Q: I want to output a date to a database in the *ISO date format. The current date is to be output to a record anytime the record is updated. I cannot use UDATE since it only provides a two-digit year. The *ISO format is YYYY-MM-DD. Is there a way I can retrieve the current year in a four-digit form?
A: The RPG special word *DATE returns the job date in your job's date format with a four-digit year. If your system format is MM-DD-YYYY, you can use *DATE and then use a data structure and a series of moves, or the Convert Date (CVTDAT) command to get your date into YYYY-MM-DD format. As an alternative, you could also use the special words *YEAR, *MONTH, and *DAY.
LATEST COMMENTS
MC Press Online