3 Replies Latest reply: Feb 5, 2016 6:05 AM by Robert Hutchings RSS

    convert eg 21. January 2015 to a date

    Robert Hutchings

      The date is in this format

      DD. MMMM YYYY

       

      I converted using  (@5  is the date field)

       

      subfield (@5 ,'.' , 1)   & '/'   &   NUM (MONTH (DATE#( PURGECHAR( @5, '. 1234567890'), 'MMM'))) & '/' & 2016 as DateInv

       

      NB Its only 2016 dates for now

       

      Why doesn't something like this work

      Date# (@5 , 'DD. MMMM YYYY')

       

      I tried everything I could think of but no joy

       

      Including converting @5 to 21January2016 (using trim and purgechar etc) before using date#

       

      Thanks for any help.