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.