Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

HELP | Convert unusual string into Date, and Time

Looked at lots of posts and am yet unable to convert the following into Date and Time fields.

Field is called LASTORDERDATE

Example value is: 01-APR-02 01.10.36.000000000 PM

I need to convert to

Date 04-01-2012

Time: 01:10:36 PM (or 13:10:36)

Any help is appreciated.

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: HELP | Convert unusual string into Date, and Time

Try the following expressions:

Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'MM-DD-YYYY')

Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'hh:mm:ss')

2 Replies
nagaiank
Valued Contributor III

Re: HELP | Convert unusual string into Date, and Time

Try the following expressions:

Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'MM-DD-YYYY')

Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'hh:mm:ss')

Not applicable

Re: HELP | Convert unusual string into Date, and Time

Thanks NagaianK

Worked like a charm.

Community Browser