Date Range Field

[whjwilson]

I am trying to format my date range field. Is it possible to have a field display a default entry of INDEF for a date that won't expire and a date can be put in the same field if needed?

Example:

Name Valid Until
Wilson INDEF
Jones 08-Jan-08
Johnson 03-Mar-07

Thanks for the help.

 

[Golom]

Not if it's a Date/Time field.

To do this you would need to use a text field and then use functions to convert the date formatted as text to a genuine Date/Time value.

Your other option is to leave it as Date/Time and then in a query

Select NZ([DateRange],"INDEF") As [Date Range], ...

 

[missinglinq]

Another alternative would be to assign as a default a date far, far in the future that would be recognized as "indefinite" by users, such as the same date in the next century!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[SkipVought]

FYI...

http://support.microsoft.com/kb/130514/

Skip,
[sub]
[red][/red]
[/sub]