Field for Text or Date

[gsrajan]

I have field in my form and the entry is required. The data type is date. I need to keep the date type as date. My problem is if the date is not available, the user has to enter "Nor Available". Is there any way I can achieve this? What are the other option available to me? The reason is this record will be exported to a pdf form which requires the Date or the text "Not Available" in the specified pdf field.

Thank you.

 

[plog]

You've got a lot of conflicting constraints there. It has to be entered, but it can essentially contain no value, it has to be a date, but it also has to accept words. You really need to rethink your constraints.

My suggestion is to allow nulls in this date field, then when exporting it you see if its null and have it say 'Not Available' if it is, otherwise spit out the date.

 

[gsrajan]

Thank you, I will think in that way.