Unknown Dates

[DHHC]

Hi everyone.

We have many dates in our database which are partly unknown.

I wish to maintain the functionality of the 'Date Field' but also enter a signifier to indicate whether a day month, or year is unknown.

It might look something like this (if an Asterisk were not an operator):

**/03/194*

(believe me, we have such odd dates in our system)

So - the question is, is there a neutral operator one may use to insert into a field such as this which will be accepted and not turfed out? (getting the old Revert Field pop-up)

Thank you very much.

DHHC

[comment]

is there a neutral operator one may use to insert into a field such as this which will be accepted

No, not in a date field. You may want to use separate fields for Day, Month and Year, or a text field for the entry - then calculate the date (or the approximate date).

[DHHC]

No, not in a date field. You may want to use separate fields for Day, Month and Year, or a text field for the entry - then calculate the date (or the approximate date).

Thanks.

Yeah - i'll have to come up with some other solutions

Cheers :)