I have the similar kind of problem as in the question asked a from someone "Convert Text to Date Format (TO_DATE)"
What I am trying to do is I have a SQL table connected to a Access DB.I generate views from these table , I am having a problem in one of the coloumns which is a string(varchar) data type in the underlying SQL(MS) table.When presenting a view for this table I want to convert it this Varchar col to Date (or format it as a Date field).
I almost tried all sql functionts to convert/format this col.
Here ia an example of my SQL statement
1)SELECT CDate([TimeWritten]) AS mydate, *
2)SELECT format(TimeWritten,"dd/yyyy") AS mydate, *
when I excute the SQL in Access I get this Error ADO ERROR:"CDATE : Is NOT A recognised function blah , blah"
How can I reslove this problem.
Any help plsss??
Thank you in advance.