Validation Rule: format([___]."Short Date") 1

[DajTwo]

Hi all

Something weird is happening.

The validation rule of a field [audit_physical_date] in a form is as follow
>=Format([prepost_date],'Short Date') or Is Null
(the Format command is required to transform a MM/DD/YYYY HH:MM field in Short Date.

The input mask of the field [physical_date] is 99/99/0000;0;#

All was working well until this

If
[prepost_date] is 03/06/2009 and
[physical_date] is 03/09/2009 all is fine

If
[prepost_date] is 03/06/2009 and
[physical_date] is 03/10/2009 or 03/11/2009 or greater, the Validation rule request a date greater than 03/06/2009.

I dont get it.. The date is greater and the format of the fields is the same..

Can someone help me on this?

Thanks

If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[PHV]

Have you tried this ?
>=Int([prepost_date]) or Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DajTwo]

PHV,

Thanks for the information.

It does work however I dont understand why. I will have toresearch the int command.

GREAT THANKS for the quick fix!!!

If I did not say it before, I really appreciate the time and expertise of the users on this forum.