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:
How should I do this?
Feedback highly appreciated!