# Field Date - Dates before 1899
**URL:** https://community.glideapps.com/t/field-date-dates-before-1899/65339
**Category:** Report a Bug
**Created:** [August 24, 2023, 10:10am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339 "2023-08-24T10:10:01Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Tu\_Nacionalidad](https://community.glideapps.com/u/Tu_Nacionalidad)
#### Post date: [August 24, 2023, 10:10am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/1 "2023-08-24T10:10:01Z")
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.
Thank,
Best Regards,
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 24, 2023, 10:24am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/2 "2023-08-24T10:24:28Z")
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:
---
### Author:  [@Tu\_Nacionalidad](https://community.glideapps.com/u/Tu_Nacionalidad)
#### Post date: [August 24, 2023, 10:31am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/3 "2023-08-24T10:31:18Z")
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.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 24, 2023, 10:31am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/4 "2023-08-24T10:31:57Z")
Why is it not possible?
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 24, 2023, 9:21pm UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/5 "2023-08-24T21:21:52Z")
Hola!
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.
```auto
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"
else
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!
,
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 25, 2023, 1:54am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/6 "2023-08-25T01:54:32Z")
I wasn’t necessarily suggesting that anything be done manually 😉
---
### Author:  [@Tu\_Nacionalidad](https://community.glideapps.com/u/Tu_Nacionalidad)
#### Post date: [August 25, 2023, 5:41am UTC](https://community.glideapps.com/t/field-date-dates-before-1899/65339/7 "2023-08-25T05:41:39Z")
Muchas gracias Gustavo 😉