Easy Date/Time Question

[Guest]

How can I have a date/time field that is used in an equation, but also able
to type in it "TBD". Sometimes this date is not known, but will be added
later. Leaving it blank just doesn't give the same info. Thanks

 

[Guest]

I'm affraid you can't type anything except dates/time in date/time data
field.

You may try this:

1) Create a new field (dbText).
2) In form I'd reccomend some code (DateField_AfterUpdate) that will check
if user input was date (see IsDate function) or "TBD".

HTH

V.

 

[Guest]

Yes! But sometimes they need to diplay blank field, not just "TBD" if date
is null. :-/
V.

Can't "TBD" is text and a Date field can't handle text.

I do NOT recommend that you change your date field to a text data type.
That
would be bad.

Just leaving it blank (actually Null) is good enough. If you want to see
TBD
show up in a query, you could do an IIf statement.

IfNull: IIf(IsNull([DateField])=True,"TBD",[DateField])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

How can I have a date/time field that is used in an equation, but also
able
to type in it "TBD". Sometimes this date is not known, but will be added
later. Leaving it blank just doesn't give the same info. Thanks

 

[Guest]

Thanks Jerry- I figured it would need some sort of equation that was based on
null- just wasn't sure what it was. Thanks for the help. I think it will be
ok for all null fields to read "TBD". If not I will look into Vladimir's
suggestion.

--
Thanks,
Nikki

Can't "TBD" is text and a Date field can't handle text.

I do NOT recommend that you change your date field to a text data type. That
would be bad.

Just leaving it blank (actually Null) is good enough. If you want to see TBD
show up in a query, you could do an IIf statement.

IfNull: IIf(IsNull([DateField])=True,"TBD",[DateField])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

How can I have a date/time field that is used in an equation, but also able
to type in it "TBD". Sometimes this date is not known, but will be added
later. Leaving it blank just doesn't give the same info. Thanks