Date Conversion

[varunreddy]

Hi All,

I have dates in the following format:

1-1-2016

2-1-2016

3-1-2016

2016/April,

2016/May

Now I want to convert this into Month Year (i.e. May 2016).

Can anyone help me with this?

Thanks in advance!

Regards,

Varun

[sunny_talwar · Accepted solution]

May be like this:

MonthName(Alt(Date#(DateField, 'D-M-YYYY'), Date#(DateField, 'YYYY/MMM'))) as MonthYear

[varunreddy]

Sunny this equation is displaying dates with the format May/2016.

It is not displaying dates with 1/1/2016

[varunreddy]

Sunny,

Got it.

Thanks for the quick response.

Cheers,

Varun