Using date and times with Xano

Anyone using Xano for external collections. I’m having an issue getting the date/time coming from Xano to be in the right format for Adalo components. I change the Unix to Y-m-d H:i:s but Adalo reads them as text rather than date.

1 Like

Hi,
I haven’t used xano yet, setting it up to move away from Airtable. But have you tried to check the format in the external collection? You can change the field format:

image

Btw can you share how you filter data from Xano? in the lists? Thank you very much.

Here is a screenshot of my xano API call to GET a list of appointments.

My trouble is now POSTing a new appointment with 2 timestamps in a format Xano can read correctly.

Also, here is a link to a video showing how to GET timestamps formatted correctly.

1 Like