topic Re: Text to date format in script in QlikView

Text to date format in script

Anonymous — Mon, 15 May 2017 05:39:44 GMT

Hi ,

Can anyone help me in getting the year?

I tried the below script but it not working ...

ABC:

LOAD Date#(Date)as Date,,

Year(Date#(Date)) as year,

Name,

Product,

Sales FROM CORE_DUP\123.txt (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: Text to date format in script

swuehl — Mon, 15 May 2017 08:24:47 GMT

Have you tried with the correct date format?

SET DateFormat = 'M/D/YYYY';

ABC:

LOAD Date#(Date) as Date,

Year(Date#(Date)) as year,

Name,

Product,

Sales FROM CORE_DUP\123.txt (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: Text to date format in script

Anonymous — Mon, 15 May 2017 08:33:04 GMT

Thanks Stefan,

Re: Text to date format in script

PrashantSangle — Mon, 15 May 2017 08:36:52 GMT

Hi,

try like

date(date#(Date,'M/D/YYYY'))

Regards,

Re: Text to date format in script

Anonymous — Mon, 15 May 2017 11:07:09 GMT

Hi,

If you tried the above script then you need to remove double "," from your script

As per your script itself you can able to get the year.

Please find the below script(Removed only the ,)

ABC:

LOAD Date#(Date)as Date,

Year(Date#(Date)) as year,

Name,

Product,

Sales

FROM

[123.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: Text to date format in script

qlikview979 — Mon, 15 May 2017 11:37:29 GMT

Hi Try like this

LOAD

Date(Date#(Date,'MM/DD/YYYY'),'DD/MM/YYYY') as Date1,

Name,

Product,

Sales

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Regards