Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to convert a date that is formated as "YEARWEEKDAY" to "Year-MONTH-DAY" can anyone help me please!
Hi,
Use MakeWeekDate() funcrtion
Date(MakeWeekDate(Left(Date,4),Mid(DateField,5,2),Right(DateField,2)),'YYYY-MMM-DD')
Hope it helps
Celambarasan
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.
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