I have set of data which is linked to timestamps in the form of a string, eg "5/17/2018 13:35:44.746977".
I have tried using this code to convert the string to a DateTime object
ds = "5/17/2018 13:35:44.746977"DateTime(ds, Dates.DateFormat("m/d/y H:M:S.s]"))
Which works fine if the data does not contain the microseconds part, however I can't figure out how to extract the full time including the microseconds. Is there a way to do that?
For example, dropping everything from the string except for the seconds count, or similar?
Hi,
I have set of data which is linked to timestamps in the form of a string, eg "5/17/2018 13:35:44.746977".
I have tried using this code to convert the string to a DateTime object
ds = "5/17/2018 13:35:44.746977"
DateTime(ds, Dates.DateFormat("m/d/y H:M:S.s]"))
Which works fine if the data does not contain the microseconds part, however I can't figure out how to extract the full time including the microseconds. Is there a way to do that?For example, dropping everything from the string except for the seconds count, or similar?
Kind regards