>Ellen....
>
>You have to decide if you want your date to be input as text or as an actual date. IF text, then use the CTOD('09/21/99') function, convert to date
>If a date, then you can convert it back to text with DTOC.
Larry,
This code has Y2K problems. Look at the DATE() function to create a Y2K compliant date.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer