Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z

LNitz — Sat, 10 Jun 2023 23:38:20 GMT

I have used the custom date format generator to produce this custom format (which does not work):

The format I received from Twitter has th period between seconds and hundredths, but that is not an option in the date format builder.

Re: Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z

jthi — Wed, 13 Oct 2021 07:14:49 GMT

The issue might be with the Z, not with milliseconds.

Names Default To Here(1);

date_str = "2020-06-11T03:18:30.123Z";
Show(Informat(date_str, "Format Pattern", "<YYYY><-><MM><-><DD><'T'><hh24><:><mm><:><ss>"));
//drop Z
date_str = Left(date_str, Length(date_str) - 1);
Show(Informat(date_str, "Format Pattern", "<YYYY><-><MM><-><DD><'T'><hh24><:><mm><:><ss>"));
date_with_ms = Format(date_formatted, "yyyy-mm-ddThh:mm:ss", 25,3);
show(date_with_ms);

topic Re: Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z in Discussions

Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z

Re: Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z