Convert UTC date string from API into a date

I’m getting a UTC date string like this “2024-02-15 02:11:13 +00:00” back from an API call that I need to save as a date in the bubble database.

Have tried setting the data type of this API field as both “date” and “text”, however neither has worked. The result if an empty date value in the DB.

Is there a solution to this?

Sounds like an issue with the data coming through from the api, have you checked in the logs to confirm its passing a value?

Ahh yes, its working now. My brain was obviously lacking its normal levels of caffeine:smiley:

1 Like