To store the date in particular format in QVD - Qlik Community

Report Inappropriate Content · ‎2017-05-01

Hi,

I am looking for inputs on one issue.

My date columns data in input file is having dates in both formats DD/MM/YYYY HH:MM:SS and DD/MM/YYYY HH:MM:SS.

I need to make changes in my script so that it will store the date only in DD/MM/YYYY format in QVD.

Thanks in advance!!

Rohit

kaushiknsolanki · ‎2017-05-01

Try Date Function.

Load *,

Date(Floor(DateField),'DD/MM/YYYY') as NewField

From XYZ;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!