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!