Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day All~
I just want to ask how can I come up with a date with my data as 'January 2011, January 2012, February 2011, and so on.
I want to get the Month name and Year of the dates I have mentioned.
Thanks in advance,
-Donna
You can use
=MonthName(DateField)
it will give you like Jan 2011, Feb 2012 ....
Hi,
Write
Monthname(field name)&' '&Year(field name) as Monthname&Year
Please share your sample data
Set your monthnames in script as like
SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
Use expression as Month(datefield)&' '&Year(datefield)