topic Re: Convert text to date format in QlikView

Convert text to date format

amit_shetty78 — Mon, 16 Dec 2013 13:34:51 GMT

Hi All,

I have a date value coming in from a text file in the following format: '01-APR-13 00.00.00.000000000'.

I would like to convert this into a Qlikview date format field.

Can you please advice on how to convert this?

Appreciate any help on this.

Thanks.

Anonymous — Mon, 16 Dec 2013 13:39:03 GMT

Amit

Try something like:

date ( date# ( left( '01-APR-13 00.00.00.000000000',9) , 'DD-MMM-YY'))

Best Regards, Bill

amit_shetty78 — Mon, 16 Dec 2013 13:48:04 GMT

Thanks Bill. This works...

Anonymous — Mon, 16 Dec 2013 13:54:55 GMT

Amit

Glad you are on the road.

Was that the Correct Answer? Nudge, nudge........

Best Regards, Bill

amit_shetty78 — Mon, 16 Dec 2013 13:59:33 GMT

Hi Bill,

Yes, It was the correct answer. I looked around but didnt find the option to mark it as the correct answer.

Probably its because I didnt mark it as a question?

B Rgds,

Amit.