You must Sign In to post a response.
  • Category: SQL Server

    Query is not running in MS Access 2007....

    Below query is running in MS Access 2007. But It shows the blank output. It doesn't show any record even if it has some record in range of Date. Why?
    ------------------------------------------------
    SELECT * FROM EmpDetail WHERE JoinDate BETWEEN #03/01/2017# AND #08/01/2017#;
  • #769241
    I have just changes above query as follow and it runs successfully .
    SELECT * FROM EmpDetail WHERE JoinDate BETWEEN #2017/01/03# AND #2017/01/08#;
    But, If I have set dd/MM/yyyy format in 'Regional and Language option' of Control panel, then why is it running successfully?


Sign In to post your comments