Discussion Board for collaboration related to QlikView App Development.
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 :
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 ??
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
can you explain more please. i need my date and time field
Can you attach sample QVD to test? I've not got this kind of issue
or just change the date format option in the propreties.