Extract month from MM/DD/YYYY format

[#1]

Hi everyone,

I am trying to extract the month from my date format, however I am not doing it correctly. Should I create a timestamp for my dates and extract the month only after?

[rubenmarin]

Hi Pedro, if that's not your regional date format you call tell QV wich date format is, to extract month you can use:

=Month(Date#(Day, 'MM/DD/YYYY'))

Notice that internally date is a number, looking on your Day list box you can see that values are left aligned, this tells that it is a string, not a number (numbers are right aligned), so for Qlikview Day field is text, not number (=not date).

[anbu1984]

First convert your input to Date using Date#()

Load *,Month(Day) As Mth;

Load Date#(Day,'M/D/YYYY') As Day,Count From Source;

[#4]

But I am already doing it!

From my script:

" Date#(('$(vFileDate)'),'MM-DD-YYYY') as Day,"

But only I do it for the secound time it works:

" Date#(Day, 'MM/DD/YYYY') as Day234"

In Qlikview Day is a string but Day234 is already a date. Why it only works when I call for the second time the same function?

[rubenmarin · Accepted solution]

I think is for the separator, in the first case you're using '-' instead of '/'

[#6]

The machine is always right. I dont know why I didnt notice that.

Thanks!

[jpapador]

Replace Month(Day) in your script with the following:

Month(Num(Date#(Day, 'M/DD/YYYY')))