What format should I use to POST a date ?

Clem

Hello,
I'm using Xano with Bravo Studio to build a sports app. For this occasion, I need to POST the date of the event, which is a field that comes from Bravo Studio. To do this, I've created my POST request which expects a "Date" value as input, however, I don't know what test data to use for the request to work in Xano. For the moment, whatever input I enter, I get the following error message:

Thanks for your help

Ray Deck

Is event_date of type date or timestamp? This number looks like a UTC timestamp, which should be fine for the latter. If you share more of the setup, the community can help more.

I also run daily office hours and a loom-enhanced community at State Change Pro where we knock down these kinds of issues every day.

Guillaume Maison

to complete what @Ray Deck says, the value transmitted is a timestamp :

So the Input parameter should be timestamp. Moreover, you'll have finer possibilities to manipulate dates with timestamp (imo).

Michael Udinski

@Clem Date input types need to be wrapped in double quotes. Moreover, a Date format will be accepted as follows: "YYYY-MM-DD"

Clem

@Michael Udinski I've just tried it but it doesn't work either. Do you know where it could be coming from?

Michael Udinski

@Clem - i'm wondering if there is a cache issue. I see you're using the DB link input type. Was this field originally a timestamp and then changed to a date field by chance? Can you try deleting and re-adding the input?

Clem

@Michael Udinski - I've tried deleting the input and putting it back. I've also deleted and recreated the Event_Date field in my database and cleared my browser's entire cache, but I still get the same error.

Michael Udinski

I'm having trouble recreating this on my end. Can you please show what you're doing to the input in the function stack?