text in a date field

[errorist]

Simple problem but i can't figure it out.

i have some fields with a date-format, but i need them to be automatically filled with the text "N/A" if an option is checked in another field.

I tried calculations but the outcome needs to be a date and cannot be text, so N/A changes into "?" because text is not accepted

I can switch the format of the datefield to text but that's not really a good option. How do i get a text outcome in a date-restricted field?

thanks

[Charles Delfs]

you can force it in via an auto enter (in define fields)but once you erase it it's gone and you can't put it back.

or

Create a second fields called cMy_Date_Entered that is a calculation something like this:

Case(MyDate_Availability="","N/A")

Put the second field (do not ally entry) over top the first one

Charles

[BobWeaver]

I would go with Charles's second suggestion.

I strongly recommend that you don't put anything in a date field except date, or else leave it blank. I've had some really bad experiences cleaning up databases where a field has been used for multiple purposes.