If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Date format

I am working with an existing database and have a table with a field called "Year". However, the data in it is not in date format, it's just text.

The year data is entered in the format of "1997/98" and "1998/99" and so on.

Is there a way of changing the data type to Date/Time and being able to specify a custom date format? I can't be losing the data and some people here are entering actual text into this field by accident (I know don't get me started!)

That works for tabbing but the problem is when the user clicks into the field using the mouse - any ideas?

Rusty

PS - I know it's a matter of the user just pressing the Home key but they really are being pedantic about this...

Tell them they'll need to recode the entire db in order to eliminate their issue. The recode will need to be in a different language all-together, and you will need a good 6 months to learn that language. The field issue should be fixed sometime next year. In the mean time, deal with it.