Neighbour_Gal
New member
- Local time
- Yesterday, 20:23
- Joined
- May 16, 2017
- Messages
- 3
I am creating a database for the church where I work.
On my source spreadsheet, some of the baptism dates are complete: mm/dd/yyyy
but others only have the year: yyyy
When I imported the data, the Baptism Date field was imported witha data type of Date/Time. I just noticed that for the records where there was only a year given, there is now an incorrect date. For example, a baptism date of 1947 gives me a date of 04/30/1905.
I tried changing the data type of that field to text, but this did not fix the errors.
How would you go about solving this problem? Thankfully, I have only about 120 records and not all of those have problems. I could go through each one individually and fix them, but if there is a simpler fix, that would be nice.
On my source spreadsheet, some of the baptism dates are complete: mm/dd/yyyy
but others only have the year: yyyy
When I imported the data, the Baptism Date field was imported witha data type of Date/Time. I just noticed that for the records where there was only a year given, there is now an incorrect date. For example, a baptism date of 1947 gives me a date of 04/30/1905.
I tried changing the data type of that field to text, but this did not fix the errors.
How would you go about solving this problem? Thankfully, I have only about 120 records and not all of those have problems. I could go through each one individually and fix them, but if there is a simpler fix, that would be nice.