AnsweredAssumed Answered

Splitting TimeStamp field

Question asked by mz5005 on Jun 2, 2017
Latest reply on Jun 3, 2017 by mz5005

I have imported external data with a time-stamp field.

The data is really a time-stamp and not text (sorting works according to calendar).

Now I need to split the date and time parts of the time-stamp to a DATE and a TIME field.

Been trying with converting to text, then with memvars etc, but I do something wrong.

Timestamps are in European date- and military time format, with milliseconds, like this:

 

25.02.1992 00:00:00.000

 

How should I do this?

 

Feedback highly appreciated!

Outcomes