On 23/10/10 22:48, Michael Adams wrote:
On Sunday 24 October 2010 06:59, AG wrote:
Question about Base.
In table I defined a field "date" to take year only (I don't want days
or months) for article publications. I selected user defined in the
field properties and stipulated YYYY. The example shows up as 1903 and
the format field shows 1900.
Now into the user form input, I enter 1991 into the date field and tab
to the next field and the date converts into today's date with the
format 23/10/10.
How do I stop Base doing what it wants to do and make it to do what I
want it to do?
Irrespective of the format it is viewed in, a date is stored in full format.
You have two options:
* format your input field.
* store the year as a number (Integer).
HTH
That was going to be my second option - formatting it as an integer.
Doesn't make any sense though to have a user defined format if it
doesn't apply when defined and required for that field though, does it?
Cheers
AG
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
