Create Qvd to store all current month dates till today but for all previous months only month end dates.

[wiz_nerd]

Note : I have complete data range from 1/1/2020 till today 6/1/2021 shown below

Input Date Range 

01/01/2020

till

06/01/2021

and I just want to store the values in QVD shown in the Image

Current month all dates till today and previous months only Month End values.

Output Required:

and store in qvd.

@sunny_talwar  @rbecher  @Gysbert_Wassenaar@rwunderlich@Anonymous@nicolett_yuri@jagan@maxgro@stevedark@Peter_Cammaert

[tresesco · Accepted solution]

Try using a where clause like:

WHERE 
SnapshotCFT >=MonthStart(Today()) and SnapshotCFT<=Today()
or
(SnapshotCFT <=Today() and Floor(SnapshotCFT)=Floor(MonthEnd(SnapshotCFT)));

[wiz_nerd]

Thanks @tresesco , for your time.