1 Reply Latest reply: Sep 27, 2012 9:28 AM by Stefan Wühl RSS

    numdat

      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