AnsweredAssumed Answered

Cleanest  way for Timestamp to (different) Date format conversion

Question asked by mz5005 on Jun 4, 2016
Latest reply on Jun 5, 2016 by 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!

Outcomes