Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

Try Date Function.

Load *,

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

From XYZ;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".