Derive Date

[#1]

Hi,

I have field '201305'.

I would like to derive a Reporting Date ( can be start daet of the month) from the above .

How can i get it.

Thanks

Thejo.

[tresesco]

your requirement is not very clear to me. if your '201305' is a date of format yyyymm then you can derive the date like :

date#('201305', 'YYYYMM')

[#3]

I have a column where i have the month year in the format of YYYYMM Like 201305.

I need to derive the date from this field.

[tresesco · Accepted solution]

then try like :

date#( YourDateField, 'YYYYMM')

or even you can use date function to get your desired format out of this like :

Date(date#(YourDateField, 'YYYYMM') , 'DD-MM-YYYY')