date formatting

[master_student]

Hello friends

I have a date field that has this format :yyyymm

I would like to change it like that DD/MM/YYYY

any idea?

Thanks a lot

[maxgro · Accepted solution]

date(date#(billing_period, 'YYYYMM'), 'DD/MM/YYYY')

another one

date(MakeDate(left(billing_period,4), Right(billing_period,2)), 'DD/MM/YYYY')

[surendraj]

In List box--> Properties---> number tab--> Override document settings---> click on Date..(Override your format as u want).

[puttemans]

Have a look at this document please. It helps me most of the time with these kind of issues 🙂