Issue with custom date format

Hi, I have a API that receives dates with values like this; 2017-12-28T23:53:58.176Z, Im trying to use custom formats:

yyyy-mm-dd hh:mm:ss.sssZ

But none of then work, please your help.

Thank you,

Rodrigo F.

I ran into this exact problem while using the Youtube Data API (same format you’re looking for). I ended up stringing together a couple formats to make it work. For testing, I wanted the current date/time plus five seconds entered in format you’re looking for. Here is a screen cap of what I did for that use case:



Hey, long shot but I’m hoping you can help!

I’ve followed your recipe to a t, but I’m still getting an API error that it cannot parse the data.

I’m trying to send the dates I capture to act as dynamic values for my API GET call.

Unfortunately, no matter what I do it doesn’t seem to work.

Do you have any suggestions?

You need


But the time zone must not be users time zone - set it to UTC

which is UTC time zone

And your HHMM needs to be capitals
And your T and Z need quote marks

Hey! Thanks for the response. I discovered that the date being passed through was only yyyy-mm-dd, so everything is fixed! :smiley: