date

master_student — Mon, 05 Dec 2016 20:54:20 GMT

Hello everyone

I have a date fiels like that yyyymm example 201602 I would like to convert this field date into DD/MM/YYYY

any idea please

for example if I have

5 as KPI for the period 201602

I want this result :

01/02/2016 5

.......

30/02/2016 5

Any idea please??

Thanks

Re: date

sunny_talwar — Mon, 05 Dec 2016 20:58:46 GMT

May be like this:

Date(Date#(DateField, 'YYYYMM'), 'DD/MM/YYYY')