How to set a date field

[bigzilla]

Is there a way set a date field so it will only accept a date that is formatted with the / separator and no other?

 

Thanks,

 

Bill

[FileMakin' Tom]

Hi Bill . . .

 

Create a calc text field such as

 

Left(Date,2) & "/" & Middle(Date,3,2) & "/" & Right(Date,2)

 

or for a full year end it with Right(Date,4)

 

Then if you need it to be a date, create a calc date field which uses the text field as its calc definition.

 

 

Tom

[bigzilla]

Hi Tom,

 

I'm sorry, I didn't make myself clear. I do not want the user to be able to enter a date in any way other than 4/22/2005. If they enter 4-22-2005 a dialog box would tell them that a / must be used.

 

Thanks Tom

 

Bill