This question seems pretty basic, but I’m trying to store some JSON data from Acuity Scheduling as a date/time field to then re-format it how I want. The issue is that Bubble doesn’t like how the data is coming in. It seems like Bubble should be able to pick this up, since it’s formatted as an ISO 8601 date.
Have any of you all dealt with this? If so, how did you handle it? I’m considering storing the time and date variables separately but that then leaves me with the issue of storing the time zone as a text field which probably will give me trouble converting too.