Default Value

[johnbird1988]

Hello

I have a some fields that are in DATE/TIME Date Type. I would like the default value for this to be "N/A". Is there a way this can be done?

Thank you
John

 

[Joe4]

"N/A" is not a valid date, so I don't think you are going to be able to use that as the Default Value of a Date/Time Data Type field.

You could set it up as a Text field instead, but then you would have to convert it to Text in a query if you need it to behave like a date (and you might have to manually add SQL verification code to ensure they are entering valid dates).