Date format

[sat_tok52]

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]

Try like this

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

Or

Date(Date,'MMDDYYYY')

[its_anandrjs]

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]

Hi ,

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

[Chanty4u]

chk dis too,

Dealing with date formats in QlikView and QlikSense

The Date Function