View original (French)

VBA: Convert a text field to date.

titine31 -  
 Titio -
Hello,
I'm working in Access and I have a data type issue in my database.
My database comes from a link with an Excel (.csv) file and all fields are in "text" format.

I want to work with dates and make queries searching for information between two dates. But since my field is in text format, it doesn't work.
Can someone help me?

Here’s how my date is displayed (in text format): 01/01/2007/0:0:0

Thanks in advance and see you soon ;)
Configuration: Windows XP Internet Explorer 6.0

6 réponses

Réponse 1 / 6
Fing
 
Hello
CDATE is a VB function, so to use it you need to convert the fields datefin and datedeb to the date format
then when saving the data in these fields, use CDATE for formatting the text as a date
The rest is very simple.
Thank you
2