Find the earliest and latest from a list of dates sent by webhook

How To
,
1

I have a list of dates sent by webhook, They will always be the same day, only the hour changes I can adjust the delimiter, add quotes, etc
I have tried a few formats and modules but I am having issues figuring this out.

I just need to set the earliest and latest time as variables

“Friday, October 25, 2024 11:00 AM”,
“Friday, October 25, 2024 12:00 PM”,
“Friday, October 25, 2024 1:00 PM”,
“Friday, October 25, 2024 2:00 PM”,
“Friday, October 25, 2024 3:00 PM”

2

Solution:

I am able to format dates before sending through webhook, so first I formatted to Unix Timestamp, values are received like this:

Start dates
1730206800, 1730210400, 1730214000, 1730217600, 1730221200

Then I used Parse JSON to create an array

image
image638×424 32.5 KB

Now I can find smallest and largest and parse the result back to date format for use

image
image497×717 26.1 KB

1 Like
3

I was trying to incorporate timezones, but I realized the timestamp will be formatted in the current account timezone, so daylight savings would be baked in already. (I think?)