Discussion Board for collaboration on QlikView Scripting.
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?
Solved! Go to Solution.
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?