Date Format/ Input mask

[Guest]

I am trying to change the format/input mask of a field so that I type in the
4 digit year and it displays the 4 digit year.

Format: yyyy
Input mask: 0000

It doesn't work.
When I type in a 4 digit year it gives me an error message:
"The value ypu entered isn't valid for this field. For example, you have
entered text in a numeric field or a number that is larger than the field
size setting permits

 

[Guest]

A date/time data type can only hold a full date/time value, not just the
year. Change the field's data type to an Integer Number. You won't need to
format it, just use an input mask to ensure that 4 digits are entered.

Ken Sheridan
Stafford, England