Field Date - Dates before 1899

I have an app for genealogical research. My customers need documents about their parents born, and then, need put dates before 1899.

The field Date dont allow put dates before 1899, for me this is an bug or issue before.

Best Regards,

The DatePicker wont allow you to select dates prior to 1900, but they are supported in the Glide Data Editor.

So what you could do as a work around is enter the date as a number, and then use the Text to Date column to convert that number to a valid date.

For example, let’s say you want to enter the date 27th June 1632 - use a Number Input component to enter it as 16320627 (YYYYMMDD), and then convert it.

Here is how that looks:

CleanShot 2023-08-24 at 18.22.47@2x

Thank you very much for you answer and workaround, but in case of my customer (users of the app) this UX is not possible. I guess the best option for now is to leave it as a text type field.

Why is it not possible?


If you don’t want to follow Darren’s suggestion and do it manually, you can use this JS code to validate user input and get a valid date in most cases.

var date=p1.split("/").map(Number)
let dd=date[0],  mm=date[1], yy=date[2];

let myDate= yy+"/"+mm+"/"+dd;

//  Check if all values are Number and the Date is valid
if (!yy || !mm || !dd || isNaN(new Date(myDate)))
   return "Error"
   return myDate

Due to you are in Spain (I guess so) and use the DD/MM/YYYY format, your Date column (text) will accept values only in this format and if everything is fine, you will have a new value but with YYYY/MM/DD format if you want to keep/use it on your APP.

Espero te sirva… saludos!


I wasn’t necessarily suggesting that anything be done manually :wink:

1 Like

Muchas gracias Gustavo :wink: