Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 PINKDNow 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
Try
num(Date#(BEDATA,'YYYYMMDD')) as BEDATA