I have a terminationDate field and obviously it will be null for some records, however access is putting in 1899/12/31 for the null records?
Below is my query
FormattedDate: Format([terminationDate], "yyyy/mm/dd")
Asked
Active
Viewed 31 times
0
MasterOfStupidQuestions
- 925
- 1
- 16
- 37
-
1Are you quite sure you do not have a time element in terminationDate? – Fionnuala Jan 08 '15 at 16:23
-
@Fionnuala absolutely, there is no time element involved with this field. – MasterOfStupidQuestions Jan 08 '15 at 16:24
-
In MS Access a null date returns null. You need to use the immediate window to find out what your field really contains. – Fionnuala Jan 08 '15 at 16:27
-
`SELECT Format(Null, "yyyy/mm/dd") AS FormattedDate` returns an empty string. So if your `Format` expression returns "1899/12/31", `[terminationDate]` must contain something other than Null. – HansUp Jan 08 '15 at 16:32