Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Changing Date Format

I am having trouble saving dates into an Access 1.1 DateTime field. The aplication I am writing is for the European market, so international dates are a problem as well. I am putting the current date into a Truegrid table as a string. When I try to convert it into a date I get Type Mismatch error. I get the same error if I try and save it to the database. Any advice would be most welcome. Thank you.

Try this for converting string to date:

DateField = CVar(String)
For converting from date to string, try using the Format$ function like this:
String = Format$(DateField, "MM-DD-YY")
Also be aware that your problems might lie with the codepage that your keyboard is set to. If you're using a "US English" codepage and are trying to translate to a different (i.e. European) format it might be causing the type mismatch.
DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date