Discussion Board for collaboration on QlikView Scripting.
I am looking for the right command to make a date numeric for using in the calender table
PINKD day is 6 long, format YYMMDD and this command is working.
Now i want the same for a field (BEDATA) , 8 long with format CCYYMMDD
num(makedate(BEDATA)) as BEDATA
is not working
Anyone an idea?
Go to Solution.
num(Date#(BEDATA,'YYYYMMDD')) as BEDATA