locked
Access 2003 SELECT Convert Date problem RRS feed

  • Question

  • User451945003 posted

    AND (([dbo_tblCompanies.C_VerifiedDate])<CONVERT("DATETIME",'2010-06-20 00:00:00',102))) 

    Getting Undefined fuction 'CONVERT' in expression from ACCESS 2003.  Had this working but don't know what I did.

    Sunday, June 27, 2010 9:46 PM

Answers

  • User1668404196 posted

    Hi Good day, Try using cdate instead of convert function 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 28, 2010 12:25 AM