Convert data type to timestamp with milliseconds

#1

Hi,

I receive a file and in that filename is a timestamp down to the millisecond.

How can we convert this in EasyMorph to a timestamp ?

Example:
The part after the second underscore is the datimestamp.

mut_gen-ondernemingVKBO0200_20210921100458000.csv

#2 
  date("20210921100458000", "yyyyMMddHHmmssfff")

All the format options are here: syntax:functions:date [EasyMorph Help]

1 Like
#3

Hi,

Thanks that works !
I had a look at the documentation before I made the post but is the “fff” mentioned somewhere because that’s new to me apparently ?

Thanks !

#4

The last “See also” link in the help article mentioned in my previous post leads to a page with more formats: Custom date and time format strings | Microsoft Docs