date

[master_student]

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

[sunny_talwar]

May be like this:

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