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.
num(makedate('20'&left(PINKD,2),mid(PINKD,3,2),right(PINKD,2))) as PINKD
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?