Due Date set up?

  • Thread starter Thread starter fajita
  • Start date Start date
F

fajita

Not sure if this is happening because my table is set up
wrong? I am want to add under Due Date the option "To Be
Determined?" is this possible?
 
Not sure if this is happening because my table is set up
wrong? I am want to add under Due Date the option "To Be
Determined?" is this possible?
Click to expand...

No. A Date/Time value is stored as a number, a count of days and
fractions of a day since midnight, December 30, 1899; the text string
"To Be Determined" is not a valid date value!

What you can do is leave the field NULL and use an expression

NZ([Due Date], "To Be Determined")

as the control source of any report or form textbox in which you wish
this displayed.
 
Back
Top