Creating Date

[#1]

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

[#2]

You can use

=MonthName(DateField)

it will give you like Jan 2011, Feb 2012 ....

[khadeer]

Hi,

Write

Monthname(field name)&' '&Year(field name) as Monthname&Year

[sushil353]

Please share your sample data

[sivarajs]

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)