Make month name from today()

[#1]

I´ve set monthNames to

MonthNames='01;02;03;04;05;06;07;08;09;10;11;12';

because I use them in various variables.

I need a variable that gives me the CurrentMonthName = NOV

[anbu1984]

Let CurrentMonthName = Month(Today());

[deepakqlikview_123]

You can use if else condition

if(Month='01',Jan,if())

[Aurelien_Martinez]

Hi,

Let CurrentMonthName = Pick(Month(Today()), 'Jan', 'Feb', 'Mar', 'Apr', 'Mai', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');

Aurélien

[ali_hijazi]

use the function MonthName(Today())

this will give you Nov-2014

[#6]

Hi Aurelien

The above does´nt work

I tried to make a new variable in Settings

Variable name: Let CurrentMontName

Definition. =Pick(Month(Today()), 'Jan', 'Feb', 'Mar', 'Apr', 'Mai', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');

It does´nt give me Nov for today on this 14. november 2014??????

[#7]

Hi Ali

Because I´ve set Monthnames in hte beginning af my script to

SET MonthNames='01;02;03;04;05;06;07;08;09;10;11;12';

the MonthName(Today()) gives me 11

[Aurelien_Martinez]

See this QV file

Aurélien

[ali_hijazi · Accepted solution]

then this should work

= Pick(Month(Today()), 'Jan', 'Feb', 'Mar', 'Apr', 'Mai', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')

put this in a textbox and see

[#10]

Hi,

try these

Month(today()) is give monthname

Or

Pick(Month(Today()), 'Jan', 'Feb', 'Mar', 'Apr', 'Mai', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')