Combine date field and text field question

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

m/d/yyyy;;;"N/A"

I am trying to combine a text field and a date field. I need either NA
or TBD in the blank rows of a date column. Besides thte above format,
is there any format that you can input so instead of N/A, the user can
choose what they want to put.
 
Besides thte above format,
is there any format that you can input so instead of N/A, the user can
choose what they want to put.
Click to expand...

No.

A Date/Time field is stored as a number. You can format that number in
various ways, but you cannot store free-format text in it.

You'll need to either use a Text field, and parse the date (tricky!)
or use two fields.

John W. Vinson[MVP]
 
Back
Top