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.
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.