MakeDate Function - String to Date

[#1]

Hi All,

I have an Excel column called SystDate. This has a text string examples of which are 11/29/2013 8:02:04 AM or 12/7/2013 9:59:32 PM, Can someone assist with the formula I would use to convert this into a date using the "MakeDate" function. S

Thank You

Herbiec09

[swuehl · Accepted solution]

Makedate function is not taking a string, use date#() or timestamp#() functions for this, as advised by Michael:

Date#('11/29/2013 8:02:04 AM','DD/MM/YYYY hh:mm:ss TT')

or

Date#(SystDate,'DD/MM/YYYY hh:mm:ss TT')

[edit:]

http://community.qlik.com/docs/DOC-3102

[#3]

Thank you very much, much appreciated.

Herbiec09

[#4]

Very useful doc, I have used the time stamp option.

Thank you

H