Date Format

[#1]

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]

Hi

try like this

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

[Anonymous]

Check the below link for more info

http://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function

Thanks,

Vignesh

[Gabriel]

Hi,

Try

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