What is the difference between two field type date and timestamp?

Rajib Hasan

I am using date as field type for campaign start date and for campaign end date. I am selecting a date but it is showing invalid date. Ma I know the reason why it is not working and the solution to fix it[image.png]

Michael Udinski

 - Xano stores timestamps as a unix timestamp in milliseconds. Unix timestamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC.

https://docs.xano.com/working-with-data/timestamp#timestamps

Dates are just date mm/dd/yyyy

The invalid date looks to be an issue with Firefox. We recommend Google Chrome browser for the best Xano experience