numdat

[#1]

Hi,

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?

Regards,

Ron Laurens

[swuehl · Accepted solution]

Try

num(Date#(BEDATA,'YYYYMMDD')) as BEDATA