calender is not working

[Vinil]

Hi Friends,

I have a logic to pull the last three years monthly QVDs into the script to generate a full QVD so, in that process when my job is completing run on Dec 31st we are getting Dec 30th data but my aim is to fetch the data including Dec 31st when my job runs on Jan 1st, 2020 but it is not happening like that. Here we are getting the data correct in the original QVD.

Below is the attached logic to pull all the monthly QVDs.

Thanks,

Vinil

[Vegar]

Hi @Vinil 

I think you missed attaching the logic you are using.

BR
Vegar

[Vinil]

PFA.

Thanks,

Vinil

[Vegar]

I don't see any obvious wrongs in you script. Depending on your content in SMRY_NUM you might want to put single quotes around your variable dollar expansion like this.

WHERE SMRY_NUM >= '$(v_start_period)' AND SMRY_NUM <= '$(v_end_period)' 

[Vinil · Accepted solution]

I did in that manner but no luck.

i would like to try in with the last execution time.

Thanks for your prompt reply.

Thanks,

Vinil