topic Re: Date format not correct in QlikView

Date format not correct

Fri, 27 Feb 2015 09:08:20 GMT

Good morning, I have the following problem:

using the following formula:
dates (date # (CNDARS & CNDARA & CNDARM & CNDARG, 'YYYYMMDD'), 'DD-MM-YYYY') as [DATA FATTURA],

but I get errors because some values retrieved and formatted by the formula are wrong while others are correct.

The line in yellow have a wrong result of the formula.

Anyone have any ideas ?

Thans,

Giovanni

Re: Date format not correct

Fri, 27 Feb 2015 09:10:02 GMT

Also add that there are lines that do not have the field enhanced by the formula.

Thanks,

Giovanni

Re: Date format not correct

tresB — Fri, 27 Feb 2015 09:17:16 GMT

Single digit months are causing the issue. Try like:

dates (date # (CNDARS &CNDARA &'-'& CNDARM &'-'& CNDARG, 'YYYY-MM-DD'), 'DD-MM-YYYY') as [DATA FATTURA],

Re: Date format not correct

mukesh24 — Fri, 27 Feb 2015 09:17:44 GMT

Hi,

Try below expressions

dates (date # (CNDARS & if(len(CNDARA) = 1,'0'&CNDARA,CNDARA) & CNDARM & CNDARG, 'YYYYMMDD'), 'DD-MM-YYYY')

dates (makedate (CNDARS & if(len(CNDARA) = 1,'0'&CNDARA,CNDARA) , CNDARM , CNDARG) 'YYYYMMDD'), 'DD-MM-YYYY')

Regards,

Mukesh Chaudhari

Re: Date format not correct

maxgro — Fri, 27 Feb 2015 09:28:36 GMT

=date(makedate(20*100+12,1,17), 'DD-MM-YYYY')

with fields

date(makedate(CNDARS*100+CNDARA, CNDARM, CNDARG), 'DD-MM-YYYY') as [DATA FATTURA]