Date Format in a marco

[tonywu]

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 

[Tom]

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'
)