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: 
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Partner - Creator III
Partner - Creator III

or just change the date format option in the propreties.

QlikView Qlik Sense consultant