Error with the query in Oracle

I am using Oracle and using in my toad to check what the result is. But I am getting error as

ORA-01740: missing double quote in identifier

Here is my query

SELECT T1.Project_Id, 
       PROPERTY_NAME Project_name,
       T1.Vehicle_No,
       T1.Creation_date,
       T1.Time_In,
       T1.Time_Out
FROM 
       XXCUS.XX_SUPINV T1
   INNER JOIN XXACL_PN_PROJBUILD_V T2 
       ON T1.Project_Id = T2.Project_id
WHERE  t1.Project_Id = '" + ddlProjectName.SelectedValue + "' 
   AND Creation_date BETWEEN to_date fnd_conc_date.string_to_date('"TxtIndate.Text"') AND 
         to_date fnd_conc_date.string_to_date('"txtOutDate.Text"')"

Please suggest where I am mistaking


Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.