I’m working on a domain where some events have a specific day, month, year, and some events are missing day or month (but year must be known)
The problem is, Neo4j date default treat missed field as one. e.g 1975
gonna be save as 1975-01-01
. This is quite ambiguous in Q.A task. For example:
-
Which event occurs on
1-1-1975
? I should return exact match date rather than some ambiguous date likeJanuary 1975
and1975
are both save as1975-01-01
-
Which events occurs between
1975
and1976
should return any event occur between (included) those year regardless of day and month.