Get Month

[#1]

Hi,

I would like to get the Month. I have attached an exemple file it ends in April but it would go on.

So I have sheets with the month and in each sheet all Dates (like 01.02.2013) and no I would like to have a Listbox where I can mark January. Has someone an solution?

[swuehl · Accepted solution]

Use the Month() function:

LOAD Datum,

     Value,

     Month(Datum) as Monat

FROM

(biff, embedded labels, table is [$(vSheet)]);

edit: Or if you want to use your variable:

LOAD Datum,

     Value,

     '$(vSheet)' as Monat

FROM

(biff, embedded labels, table is [$(vSheet)]);

[#3]

Just create a new field in the script this way:

Month(Date(Datum)) as Month