Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

date format

I need to load data from qvd where creation date < 28/05/2018 and store the result in an other qvd

heres the result of my QVD :

Capture.PNG

here is my script :

load *

FROM

(qvd)

where CREATION_DATE <'28/05/2018';

the result is :

Capture.PNG

I don't know why the format of my data fiels date création change? ANY HELP pleaase ??

5 Replies
olivierrobin
Specialist III
Specialist III

hello

date is stored under this format

before the comma the date

after the comma, the hour

you have to use date() or date#() functions to format it

master_student
Creator III
Creator III
Author

can you explain more please. i need my date and time field

Anil_Babu_Samineni

Can you attach sample QVD to test? I've not got this kind of issue

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
master_student
Creator III
Creator III
Author

done.

kfoudhaily
Creator III
Creator III

or just change the date format option in the propreties.