Date format not correct

[#1]

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

[#2]

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

Thanks,

Giovanni

[tresesco · Accepted solution]

Single digit months are causing the issue. Try like:

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

[mukesh24]

Hi,

Try below expressions

1.

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

2.

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

Regards,

Mukesh Chaudhari

[maxgro]

=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]