Forum Discussion

aravindh10's avatar
aravindh10
Helper I
7 years ago
Solved

Parameter in sql query statement is not working

i  have a query where the docdate <'2018-01-01'

now i wanted to pass the date as perameter

i tried as text,date

i tried in the query statement  WHERE doc_date > '"&@docdate&"' 

it gives the error Conversion failed when converting date and/or time from character string.

 

.help me

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi aravindh10 ,

     

    Not sure if you'd like to specify the parameter in sql statement , you could probably try "&docdate&".

     

    Best regards,

    Dina Ye

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi aravindh10 ,

     

    Not sure if you'd like to specify the parameter in sql statement , you could probably try "&docdate&".

     

    Best regards,

    Dina Ye

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi aravindh10 ,

       

      If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

      Best regards,
      Dina Ye