How do i seperate day-month-year from same field

[Anonymous]

Hello,

Please find attached, how do i extract day to a different listbox also month and year using script.

Regards

[MarcoWedel]

Load

date,

day(date) as day,

month(date) as month,

year(date) as year

from yoursource;

hope this helps

regards

Marco

[mahesh_agrawal]

hi,

PFA

[ashfaq_haseeb · Accepted solution]

May be Like this.

Regards

ASHFAQ

[ashfaq_haseeb]

Updated.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi You have date till 31.2.2014 whereas feb in 2014 is having 28 days and rest all is considered to be march by default in Qlik Its  converted to 1 2 3 mar respectively.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Can you close this thread.

Regards

ASHFAQ

[MarcoWedel]

you also could change your date format in the script from

SET DateFormat='M/D/YYYY';

to

SET DateFormat='DD.MM.YYYY';

hope this helps also

regards

Marco