topic Re: Date Format Issue in QlikView

Date Format Issue

chintan1989 — Mon, 30 Sep 2019 06:08:35 GMT

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

Re: Date Format Issue

Vegar — Mon, 30 Sep 2019 06:27:09 GMT

See updated answer below

Re: Date Format Issue

Vegar — Mon, 30 Sep 2019 06:34:23 GMT

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.

Re: Date Format Issue

rathore01 — Mon, 30 Sep 2019 06:29:44 GMT

use below -

load

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

Re: Date Format Issue

chintan1989 — Mon, 30 Sep 2019 06:40:45 GMT

The Date column comes Blank.

Re: Date Format Issue

chintan1989 — Mon, 30 Sep 2019 06:41:45 GMT

The Date column comes Blank.

Re: Date Format Issue

Vegar — Mon, 30 Sep 2019 07:00:59 GMT

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

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

Re: Date Format Issue

chintan1989 — Mon, 30 Sep 2019 07:07:52 GMT

Thanks Vegar, appreciate your help.