Adding dates through Adalo

hicksmadison

I am trying to allow user to input their date of birth (front-end is Adalo).

How do I format the field on Xano and Adalo? I keep getting “Invalid format”

Michael Udinski

Hi @hicksmadison - you typically don't need time for DOB - just the date. I'd consider using a date field over a timestamp here. Xano accepts dates as YYYY-MM-DD. Adalo might send something different, I would run a test and check your API request history to see the format Adalo sends. You can manipulate the value Adalo sends in order to format it correctly to enter your database. If you are hitting an error on the input (before the value goes into the function stack), you could also use a text input type to be more flexible and afterwards manipulate the value with the function stack before adding it to the DB.