Convert text to date format

[amit_shetty78]

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]

Amit

Try something like:

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

Best Regards,     Bill

[amit_shetty78]

Thanks Bill. This works...

[Anonymous]

Amit

Glad you are on the road.

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

Best Regards,     Bill

[amit_shetty78]

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.