Parse date picker to ISO for API call

calum.rr.scott · 2025-01-08T07:41:52.536Z

Hi Everyone, I’m struggling to parse a date value selected in an element to a format which can be used in an API call.

For the API call to work I need a start and end time stamp in the following format: startTimestamp=2024-01-01T00%3A00%3A00Z&endTimestamp=2024-12-30T00%3A00%3A00Z

When I setup the call I manually added parameters like this and it worked fine:
startTimestamp = 2024-01-01T00:00:00Z
endTimestamp = 2024-12-30T00:00:00Z

When looking at the API documentation it allows me to add these values as a test parameter and gives the below format for cURL:
www.endpoint.com/example?startTimestamp=2024-01-01T00%3A00%3A00Z&endTimestamp=2024-12-30T00%3A00%3A00Z

I’ve tried setting the date picker element to a custom format and then just adding “T00%3A00%3A00Z” as arbitrary text afterwards but doesn’t seem to work. I only care about year, month, date for the timestamp so generic seconds etc would be fine.

Thanks for your help!

Baloshi69 · 2025-01-08T11:07:05.569Z

calum.rr.scott:

2024-01-01T00:00:00Z

It simple, select the date element value and choose format as custome date format : YYYY-MM-DDTHH:mm:ssZ

image1143×614 29.6 KB

i DM you a video

calum.rr.scott · 2025-01-08T19:51:17.724Z

Thanks for the response @Baloshi69 and I really appreciate the video but I’m still not getting the right data. In my screenshot following your instructions I don’t get proper date values but some text the API cannot parse.

You will see in your video also the parameters added to the page include YYYY-DD-30 instead of 2025-06-01. I think we are on the right track but any more advice you have on how to get the date numbers instead of letters would be really appreciated!

Screenshot 2025-01-08 at 19.51.47915×652 44.4 KB

Screenshot 2025-01-08 at 19.52.15857×505 23.8 KB

calum.rr.scott · 2025-01-08T19:56:31.688Z

@Baloshi69 I did it literally 2 mins after respond to you! So there is a format called “Simplified extended ISO” which gives the correct format. I would not have been able to find it without your input so thank you

Screenshot 2025-01-08 at 19.55.56356×205 9.46 KB