2 Replies Latest reply on Jun 5, 2016 1:34 AM by mz5005

    Cleanest  way for Timestamp to (different) Date format conversion

    mz5005

      We import data from an external source about currencies. These rates have a timestamp (to the millisecond).

      The format is "dd.mm.yyyy space hh.mm.ss.mmm". This needs to be converted to a date only field in format yyyy.mm.dd

      I made a clumsy work-around (converting timestamp to text - trimming etc) but I am sure there is a cleaner way using a memvar but i don't get it working properly.

       

       

      Anybody can put me on the right track? Greatly appreciated!