topic Create Date from String in QlikView

Create Date from String

Mon, 12 Dec 2016 16:52:52 GMT

Hey All,

I have tried a bunch of things, but am unable to convert the TimeCardDate (DD-MON-YY) from a string to a date field.

Any help would be appreciated - here is the format of the data:

Thanks Vince

Clever_Anjos — Mon, 12 Dec 2016 17:00:23 GMT

Please try this:

SET MonthNames='jan;feb;mar;apr;may;jun;jul;aug;sep;oct;nov;dec';

LOAD Date(Date#(lower(TimeCardDate),'DD-MMM-YY')) as TimeCardDate Inline [

TimeCardDate

02-OCT-16

09-OCT-16

16-OCT-16

18-SEP-16

23-OCT-16

24-JUL-16

25-SEP-16

30-OCT-16

]

Mon, 12 Dec 2016 18:24:31 GMT

worked like a charm - thank you