Date format

[#1]

Hi ,

I have date fields like ''YYYYMMDD''..I want to convert it into MM/DD/YYYY

and I have Fiscal week field like  'YYYYWK' ,I want to convert it into 'WK.YYYY'

How do we correct it.

Thanks

[sujeetsingh]

Use date function

[ecolomer]

=makedate(date, 'MM/DD/YYY')

[tresesco · Accepted solution]

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

Right([Fiscal Week],2)&'.'&Left([Fiscal Week],4)        // or, better convert it to date using MakeWeekdate() and then format

[MarcoWedel]

Hi SwathiRaj P,

Dual(Right([Fiscal Week],2)&'.'&Left([Fiscal Week],4), MakeWeekDate(Left([Fiscal Week],4), Right([Fiscal Week],2)))

Will react like a date field, delivering the numerical value of the weeks start date formatted as you specified.

So using this expression enables you to use this field like any other date field, i.e. without any sorting issues and working date calculations.

hope this helps

regards

Marco