Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

DajTwo

Technical User
Jul 17, 2008
157
US
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.
 
Have you tried this ?
>=Int([prepost_date]) or Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top