Date Format

[vanderson009]

I have field which contain Year and Month in Text format, I want to convert it into date format.

We have value like 201803 which is in Text format and i want to make it in date format.

Please help.

Thanks,

Villyee

[OmarBenSalem]

Date(DATE#(YourField,'YYYYMM'),'YYYY-MM') as NewDateField