Convert Date

[ashishpalkar]

Hi There

How to convert this date into

05/22/2002 to May 2015

[prabhu0505]

Date(Date#('05/22/2002', 'MM/DD/YYYY'), 'MMM YYYY')

[MarcoWedel]

‌Fixed year offset +13?

[MarcoWedel]

‌

Date(MonthStart(AddYears(Date#('05/22/2002', 'MM/DD/YYYY'),13)), 'MMMM YYYY')

regards

Marco

[MarcoWedel]

‌Or

MonthName(AddYears(Date#('05/22/2002', 'MM/DD/YYYY'),13))

regards

Marco

[parthakk]

Hi ashish,

The following part written in script allows you to dynamically get month name and year as 2015 in date format

MonthName(AddYears(DATE_FIELD_NAME,Year(Today())- Year(DATE_FIELD_NAME))) as new_date,

hope this helps you

Thanks,

Partha Kulkarni

[mohammadkhatimi]

Hie...

MonthName(AddYears(Date#('05/22/2002', 'MM/DD/YYYY'),13))

Hope this will hepls you..!!

Regards,

Mohammad

[balasundaram]

Hi

kindly you can use below expression too.

=monthname(addyears(date('05/22/2002'),13))

[senpradip007]

Have you reached your goal ? If no, please upload sample qvw as its a strange conversion as per my perspective.

[MarcoWedel]

if you want the same month in the current year, then one solution could be:

MonthName(SetDateYear(Date#('05/22/2002', 'MM/DD/YYYY'),Year(Today())))

hope this helps

regards

Marco