Date Format Issue

[chintan1989]

Hi Friends 

In attached excel , I am unable to get the date in required format ie DD-MM-YYYY. 

I tried below 2 ways , however its not working.

date(date#(DATE),'DD-MM-YYYY') as Date,
date(DATE,'DD-MM-YYYY') as Date,

Kindly help. Thanks in advance.

Regards

Chintan

[Vegar]

See updated answer below

[Vegar]

Try this

date(timestamp#(DATE, 'DD/MM/YYYY hh:mm TT'),'DD-MM-YYYY') as Date

It looks like Excel design not  intepret the date column as a date/timeatamp column but a text. That's why you need to use date#() in order to tell Qlik that the column consists of timestamp.

[rathore01]

use below -

load

date(floor("Date"),'DD-MM-YYYY') as Date,

[chintan1989]

The Date column comes Blank. 

[chintan1989]

The Date column comes Blank.

[Vegar · Accepted solution]

My bad. I typed : instead of . it should be

Date(Timestamp#(Date,'DD/MM/YYYY hh.mm tt'), 'DD/MM/YYYY') as Date

[chintan1989]

Thanks Vegar, appreciate your help.