topic Re: date format in QlikView

date format

master_student — Tue, 05 Jun 2018 11:54:01 GMT

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 :

here is my script :

load *

FROM

(qvd)

where CREATION_DATE <'28/05/2018';

the result is :

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

olivierrobin — Tue, 05 Jun 2018 11:56:19 GMT

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 — Tue, 05 Jun 2018 12:25:36 GMT

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

Anil_Babu_Samineni — Tue, 05 Jun 2018 14:19:10 GMT

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

master_student — Wed, 06 Jun 2018 08:20:02 GMT

done.

kfoudhaily — Wed, 06 Jun 2018 08:22:48 GMT

or just change the date format option in the propreties.