Question: how to convert text to date format in ms access?
Answer: Description. The Microsoft Access DateValue function converts a string to a date.
Syntax. The syntax for the DateValue function in MS Access is: DateValue ( string_date ) ... 
Returns. The DateValue function returns a date value.
Note. ... 
Applies To. ... 
Example. ... 
Example in VBA Code. ... 
Example in SQL/Queries.