topic Re: Converting date format problem in QlikView

Converting date format problem

Fri, 21 Aug 2015 14:04:11 GMT

Hi everyone,

i have a really big date data with DD.M.YYYY format and i need DD.MM.YYYY format. But QV does not interpret the date format in the right way. i tried all of the possible scipts that i know, after that i've seen nothing.

Here are the screenshots. (Second column with no scripts)

I have DD.M.YYYY, I need to convert DD.MM.YYYY.

Re: Converting date format problem

marcus_sommer — Fri, 21 Aug 2015 15:23:25 GMT

If it's already a date you could simply use date(YourdateField, 'DD.MM.YYYY') and if it's not then:

date(date#(YourdateField, 'YYYY/MM/DD'), 'DD.MM.YYYY')

- Marcus

Re: Converting date format problem

maxgro — Fri, 21 Aug 2015 15:26:32 GMT

try the bold

source:

load * inline [

14.7.2014

1.7.2014

14.12.2014

1.12.2014

];

final:

load

Date(Date#(d, 'DD.M.YYYY'), 'DD.MM.YYYY') as newd

Resident source;

DROP Table source;

Re: Converting date format problem

sasiparupudi1 — Sun, 23 Aug 2015 19:45:20 GMT

May be there are some leading/trailing spaces in the date string?

date(date#(trim(PostedDate), 'DD.M.YYYY'), 'DD.MM.YYYY')

or if you have your date in the YYYY/MM/DD format, try the following

date(date#(PostedDate, 'YYYY/MM/DD'), 'DD.MM.YYYY')

hth

Sasi

Re: Converting date format problem

Mon, 24 Aug 2015 06:38:35 GMT

Thank you all, date(date#(PostedDate, 'YYYY/MM/DD'), 'DD.MM.YYYY') this one helped me.

Best Regards

Gizem