topic Re: Date format in QlikView

Date format

sat_tok52 — Mon, 14 Mar 2016 07:45:49 GMT

Hi Guru's,

I am converting Date into below format ,but it's not showing date

Date(Date#(Date,'M/D/YYYY'),'MMDDYYYY')

Current Date format ='M/D/YYYY'

Any Help

-Sateesh

avinashelite — Mon, 14 Mar 2016 07:47:34 GMT

Try like this

Date(Date#(Date),'MMDDYYYY')

Date(Date,'MMDDYYYY')

its_anandrjs — Mon, 14 Mar 2016 07:49:19 GMT

Try this ways but check previous date format is correct other wise make it correct

Date( Date(Date#(Date,'M/D/YYYY'),'M/D/YYYY') 'MMDDYYYY')

Try to share sample data or file.

Regards

Anand

tamilarasu — Mon, 14 Mar 2016 08:06:59 GMT

Hi ,

Your syntax seems correct for me. Check your date field format again i.e 'M/D/YYYY'.

Chanty4u — Mon, 14 Mar 2016 08:10:27 GMT

chk dis too,