Date Format in a marco

tonywu — Mon, 11 Oct 2021 04:36:02 GMT

Hi Community,

i am writing a macro to extract some data for different months as per below

however i keep receiving error like this? seems to be wrong date format?

ant ideas to tackle this? i have been having difficulties with date format 😞

thanks

Re: Date Format in a marco

Tom — Mon, 11 Oct 2021 05:14:57 GMT

If you are using the macro to generate TERADATA code then make sure you are generating valid TERADATA syntax.

%zvps
(month=201909
,date_start=date '2019-09-01'
,date_end=date '2019-09-30'
)