topic Date Format in QlikView

Date Format

Mon, 23 Feb 2015 07:38:54 GMT

Hi All,

i have i date field in one table, which i want it change in other format like YYY/MM/DD,

by default it is DD/MM/YYYY.....

but the problem is when i m using DATE function like DATE(FIELD,'YYY/MM/DD') it is giving me nothing and when i am using

DATE#(Field,'YYY/MM/DD') it is giving me date values but in Different format,'DD/MM/YYYY'

i have also change the default set variable in QV but no change in Date Format.

kindly help..

thanks in Advance ....

arulsettu — Mon, 23 Feb 2015 07:47:34 GMT

try like this

DATE(DATE#(FIELD,'DD/MM/YYYY'),'YYY/MM/DD')

Anonymous — Mon, 23 Feb 2015 07:58:27 GMT

Check the below link for more info

Thanks,

Vignesh

Gabriel — Mon, 23 Feb 2015 13:50:42 GMT

Hi,

Try

Date(Num(DateField),'YYYY/MM/DD)