Hi Pedro, if that's not your regional date format you call tell QV wich date format is, to extract month you can use:
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).
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?