Convert dates

[#1]

I am trying to convert a date that is formated as "YEARWEEKDAY" to "Year-MONTH-DAY" can anyone help me please!

[CELAMBARASAN]

Hi,

     Use MakeWeekDate() funcrtion

     Date(MakeWeekDate(Left(Date,4),Mid(DateField,5,2),Right(DateField,2)),'YYYY-MMM-DD')

Hope it helps

Celambarasan

[jagan]

Hi,

Try using the below expresion

Date(MakeWeekDate(Left(DateField,4),Mid(DateField,5,2),Right(DateField,2)),'YYYY-MMM-DD')

Hope this helps you.

Regards,

Jagan.

[#4]

Hi,

You may also use the following expression:

date((Your_Date_Field_Name),'YYYY-MMM-DD') as NewDate

For example, if your date field has 22-04-2012, the above express will give 2012-APR-22.

Hope this helps.

Regards,

-Khaled