topic Re: Date Column In Qlikview in QlikView

Date Column In Qlikview

rahulsingh12 — Wed, 27 Jun 2018 05:22:23 GMT

Hi,

I have a date column where I get data in varchar not in date format.

ColA

01/2018

01/06/2018

21/12/2017 12:00:00 AM

I need to convert them to a standard date format of DD-MM-YYYY.

If I try the below i get a null date column.

date(date#(ColA,'dd/mm/yyyy hh:mm:ss am'),'DD-MM-YYYY')

What is that I am doing wrong.

Regards

Chanty4u — Wed, 27 Jun 2018 05:33:31 GMT

try this

jonathandienst — Wed, 27 Jun 2018 05:52:27 GMT

Like this:

Date(

Alt(

Date#(ColA, 'dd/MM/yyyy hh:mm:ss tt'),

Date#(ColA, 'dd/MM/yyyy'),

Date#(ColA, 'MM/yyyy)

)

,'dd/MM/yyyy')

rahulsingh12 — Wed, 27 Jun 2018 06:04:30 GMT

Hi Jonathan,

I think your solution seems to work.

I am testing it further if all seems fine I will mark your answer as the correct answer.

Regards,

Rahul