The Date is stored as 2013-02-15 13:28:48
I tried this, but it is giving me compile errors.
SELECT DateSerial(Mid(StartDate,1,4),Mid(StartDate,9,10),Mid(StartDate,6,7)) AS Expr1
FROM Secure_Access1;
The Format I'm getting the same type of errors. I'm not seeing what I'm doing wrong.