Date Validation

[BColladay]

I am on NT 5.07  I don't know if it was like this before, but...

In a date box 1112011 validates to 7/28/4845 as does 01112011

If I put 1/11/2011 it works correctly.  Also-simply typing 11 resolves to 01/11/2011 as well

[Bruce]

Hi Ben,

>> I am on NT 5.07  I don't know if it was like this before, but...
>> In a date box 1112011 validates to 7/28/4845 as does 01112011

correct. Clarion date number 1112011 is 28 july 4845.
The real problem though is that 1112011 could be interpreted as
11 December 2011 or
1 November 2001 or
Jan 11 2011

any kind of separator would be handy.

>> If I put 1/11/2011 it works correctly. 

good.

>> Also-simply typing 11 resolves to 01/11/2011 as well

correct. if you put in a number < 32 then it uses that as the day, using the current month and year.

Cheers
Bruce