topic Re: Covert to a Date Format in QlikView

Covert to a Date Format

robert_mika — Fri, 17 Oct 2014 08:12:19 GMT

What's is the best way to covert string text

Oct/21/2014

at the Load level

to read

21-Oct-2014

alexandros17 — Fri, 17 Oct 2014 08:14:41 GMT

No best but different ways depending on your need, a quick way is using Date(date, format) ....

its_anandrjs — Fri, 17 Oct 2014 08:17:31 GMT

Try this way with Date# and Date functions.

Ex:-

Table:

LOAD Date(Date#(DateField,'MMM/DD/YYYY'),'DD-MMM-YYYY') as NewDate,DateField;

LOAD * Inline

[

DateField

Oct/21/2014

];

er_mohit — Fri, 17 Oct 2014 08:20:55 GMT

Use Data and Date # function l

try this in text object

=Date(Date#('Oct/21/2014','MMM/DD/YYYY'),'DD-MMM-YYYY')

and same can do in load level just replace date string with your Datefield like

Date(Date#(DateField,'MMM/DD/YYYY'),'DD-MMM-YYYY') as Date

maxgro — Fri, 17 Oct 2014 08:26:47 GMT

you need 2 function

date# interpretation function from string to number

and then

date formatting function from number to string

in the attachment more detail

you already get the answer in previous post (replace 'Oct/21/2014' with your field)

load

...

date(date#('Oct/21/2014', 'MMM/DD/YYYY'), 'DD-MMM-YYYY') as NewDate

.....

from

....