Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Creating Date

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

4 Replies
Not applicable

Re: Creating Date

You can use

=MonthName(DateField)

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

khadeer_sparks
Valued Contributor

Re: Creating Date

Hi,

Write

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

sushil353
Honored Contributor II

Re: Creating Date

Please share your sample data

sivarajs
Valued Contributor II

Re: Creating Date

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)

Community Browser