I’m new to Make, so I took the Make Academy courses and am now trying to apply what I learned with real data.
I’m just trying to filter and sort a table within MySQL using the Select Rows from a Table API option. My table’s data was generated in the Phoenix/USA timezone. My Organization, Web & Scenario timezones are all set to Phoenix/USA timezone - and yet, when I try to filter the table by datetime, it returns results with the dates changed to 7 hours earlier.
The original datetime fields for the pickup time (pickupAt) look like this:
2024-04-14 00:34:00
2024-04-14 02:38:00
2024-04-14 09:00:00
The filter I’m using in the Settings is
PickupAt
Greater than or equal to
2024-04-14 04:00:00
The datetime for Bundle 1’s output looks like this:
pickupAt
April 14, 2024 2:00 AM
Where am I going wrong?
Thank you for any help you can give me!