validation rule

  • Thread starter Thread starter marzij
  • Start date Start date
M

marzij

I want to crate a shamsi date field
in a table i crate a string field with 8 char with name dte
when i want to get field in a form with a text box
i fill control source with dte and validation rule with
mid([dte];4;2)<13 and mid([dte];6;2])<32 and input mask
with 00/00/00
whats wrong?
 
marzij said:
I want to crate a shamsi date field
in a table i crate a string field with 8 char with name dte
when i want to get field in a form with a text box
i fill control source with dte and validation rule with
mid([dte];4;2)<13 and mid([dte];6;2])<32 and input mask
Click to expand...

mid([dte];4;2)<13 and mid([dte];7;2])<32
---
with 00/00/00
whats wrong?
Click to expand...

That's assuming that the error is that it doesn't validate correctly.


MFK.
 
Back
Top