Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor II

Date Format Issue

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

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Date Format Issue

clipboard_image_0.png

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

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

7 Replies
Highlighted
Partner
Partner

Re: Date Format Issue

See updated answer below

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Re: Date Format Issue

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Re: Date Format Issue

use below -

load

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

Highlighted
New Contributor II

Re: Date Format Issue

The Date column comes Blank. 

Highlighted
New Contributor II

Re: Date Format Issue

The Date column comes Blank.

Highlighted
Partner
Partner

Re: Date Format Issue

clipboard_image_0.png

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

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
New Contributor II

Re: Date Format Issue

Thanks Vegar, appreciate your help.