|
section of a macro executes an item that appears as
a = put( intnx ( 'day', date(), -1), mmddyy6. );
this returns to a macrovariable in another section today-1, ie. 062203
question is, what dateformat would return the value in the format
'22Jun2003'd ? with quotes and D, all of it?
pseudocode:
a = put( intnx ( 'day', date(), -1), ddMMMyyyy. );
this code is passed on to a Proc SQL which extracts data in the format
..and (datepart('01jan70:00:00:00'dt+A.occurrance) = '22jun2003'd )
|