I'm trying to pass today's date to a PS job, and the format is exactly what I need it to be (MM/DD/YYYY) when I run only this:
:SET &TODAY# =
&$PHYS_DATE_MM_DD_YYYY_s#:PRINT &TODAY#This is a screen shot from PS displaying the required date format:
So, I'm not clear on why it's giving me the following error when the date format is correct. Any ideas?
2020-02-07 10:11:24 - U00020206 Variable '&COMPANY#' was stored with value 'XXX'.2020-02-07 10:11:24 - U00020408 02/07/20202020-02-07 10:11:24 - U00020408 XXX2020-02-07 10:11:24 - U00020408 XXX2020-02-07 10:11:23 - U02000005 Job 'JOBS.PS.XXX' with RunID '40671700' started.2020-02-07 10:11:23 - U02004018 The job was successfully interpreted.2020-02-07 10:11:24 PS_MODIFY_RUNCONTROL RUNCONTROLID=XXXL,RECORDNAME=XXX,FIELDNAME=ASOFDATE,FIELDVALUE=02/07/20202020-02-07 10:11:24 The given value is not a valid date value or it is not in the format YYYYMMDD!2020-02-07 10:11:24 - U02004025 Job-script execution was aborted.