topic Get full month name in QlikView

Get full month name

Thu, 29 Mar 2012 13:03:49 GMT

Hello,

I'm runing below code it works fine.

SQLData:
//Concatenate (LatestMonth)
LOAD *,Month(DateTime) AS MonthName1
;
SQL SELECT *
FROM "Split Data".dbo."TempData_Date_JanToFeb"
Where
//DateTime >'2012-03-05 00:00:00.000'
DateTime > '$(vMaxDate)'
and datename(month,[datetime])='March'

But if i change it to

SQLData:

//Concatenate (LatestMonth)

LOAD *,Month(DateTime) AS MonthName1

;

SQL SELECT *

FROM "Split Data".dbo."TempData_Date_JanToFeb"

Where

//DateTime >'2012-03-05 00:00:00.000'

DateTime > '$(vMaxDate)'

and datename(month,[datetime])='$(vMonth)'

In variable vMonth name i'm getting name as Mar . I'm getting this from one of my previous loaded field by using peek function. How can i change it into fullname of month.

I'm using Month(fieldname) as MonthName

Let vMonth=Peek('MonthName');

Re: Get full month name

Thu, 29 Mar 2012 13:05:44 GMT

use date(fieldname,'MMMM') instead of month(fieldname)

Get full month name

Thu, 29 Mar 2012 13:17:10 GMT

thanks to help me.

Get full month name

Thu, 29 Mar 2012 14:15:53 GMT

i've a datefield with different number of dates. I'm catching the max date using peek function in a variable.

how can i get the next monthname in a variable. It should also be in the format March not as Mar

full name format i want to store in a variable.

Get full month name

CELAMBARASAN — Thu, 29 Mar 2012 14:24:02 GMT

use Text(Date(AddMonths(vMaxDateVariable,1),'MMM'))

Celambarasan

Get full month name

Thu, 29 Mar 2012 14:24:03 GMT

Not only name of the month i want to store month number is seperate variable

Get full month name

Thu, 29 Mar 2012 14:32:18 GMT

You can also try using this: Dual(Month(fieldname),date(fieldname,'MMMM')

Get full month name

CELAMBARASAN — Thu, 29 Mar 2012 14:37:27 GMT

Hi,

Yes you can use dual for this case.

=Dual(Date(AddMonths(vMaxDateVariable,1),'MMMM'),Month(AddMonths(vMaxDateVariable,1)))

Use Variable name to get Month Name and use Num(Variable name) to get month number

Celambarasan

Get full month name

Thu, 29 Mar 2012 15:29:43 GMT

it's working but when vMaxDateVariable is 12 i'm getting 2 instead of 1.

Get full month name

CELAMBARASAN — Fri, 30 Mar 2012 04:22:54 GMT

Hi,

What Expression you used in this vMaxDateVariable?is it a date or only month?

Celambarasan

Get full month name

CELAMBARASAN — Fri, 30 Mar 2012 04:29:44 GMT

Hi,

Check with this

=Dual(Date(AddMonths(MakeDate(2012,vMaxDateVariable),1),'MMMM'),Month(AddMonths(MakeDate(2012,vMaxDateVariable),1)))

better make your vMaxDateVariable as Maximum date instead of maximum month then you can use the expression in the previous post.

Celambarasan