Validation Rules

[Guest]

Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J

 

[John Nurick]

For the ID rule, try

[0-9INUT]####

For the date field, don't try to impose a format in the validation rule.
Instead, format the field or textbox the way you want, e.g.

dd-mmm-yy

Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J

 

[Guest]

Thank you.

For the ID rule, try

[0-9INUT]####

For the date field, don't try to impose a format in the validation rule.
Instead, format the field or textbox the way you want, e.g.

dd-mmm-yy

Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J