Argh!

[dancerjodi]

Access update: I'm still fighting with it. These are the annoying little issues that seem like they should be so simple, and yet take hours to figure out.

So far I've:
Searched in Google
Searched in manuals
Searched the MS Access Help file
Asked an MS Access trainer
Asked a data analyst at Partners Health Care
Asked an IS person at Partners Health Care
Asked an old co-worker from THP
Asked a random stranger who found my LJ I'm guessing from someone on his friend's list.

This is just silly! It shouldn't be so difficult to change a text variable to a date.

Comments

[mizdarkgirl.livejournal.com]

Actually big problems if it is in DDMMMYY format
http://support.microsoft.com/default.aspx?scid=kb;en-us;131933
http://support.microsoft.com/default.aspx?scid=kb;EN-US;159323

I also found this
a) For more information about changing a field's data type, search for "data type conversion," and then "Changing a Field Data Type" using the Microsoft Access Help menu. For more information about formatting dates, search for "date formats," and then "Format Property - Date/Time Data Types" using the Microsoft Access Help menu.

b)For more information about changing a field's data type, search the Help Index for "data types, converting," or ask the Microsoft Access 97 Office Assistant. For more information about formatting dates, search the Help Index for "dates, formats," or ask the Microsoft Access 97 Office Assistant.

Thanks

[dancer.livejournal.com]

I'll take a look at this Access info and see if it helps, thanks :)