Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To store the date in particular format in QVD

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

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!