topic Creating Date in QlikView

Creating Date

Fri, 15 Feb 2013 08:30:11 GMT

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

Fri, 15 Feb 2013 08:49:28 GMT

You can use

=MonthName(DateField)

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

khadeer — Fri, 15 Feb 2013 08:50:56 GMT

Hi,

Write

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

sushil353 — Fri, 15 Feb 2013 08:53:27 GMT

Please share your sample data

sivarajs — Fri, 15 Feb 2013 09:41:11 GMT

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)