Get full month name

[#1]

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');

[CELAMBARASAN]

Hi,

     Check with this

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

or

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

Celambarasan