Hi, I need urgent help on passing date as a variable in below sql query. While we are writing it as date variable it is displaying error as “No Mapping exists from object type GenericValue to a known managed provider native type” Example: "where – c.containername = ‘17505’ AND convert(date,HML…

Thanks for your help. Resolved issue, by removing quotes for variable in query. Regards, Mounika

Hello! Could you please send a screenshot of your Query inside the UiPath Studio? And aren’t you missing a " there? Try this: […] AND convert(date,HML.TxnDate) =’" & TxnDate.ToString()& "’ […] Regards,

@Lucas.Pimenta Thanks for the reply. If we use " (Double Quote), it is throwing an error as(String constants must end with a double quote). Created the TxnDate variable type as ‘DateTime’. Attached the query. Please suggest us. Thanks, Mounika [query%20screenshot]

Hello, The double quote is mandatory so you can assign the variable through the String. It’s possible to share the workflow (or the workflow just with the string) so I can check it out? Regards,

@Lucas.Pimenta attached the workflow. Thank You, Mounika CamstarDBsap.zip (1.4 MB)

Glad you solved :slight_smile: Regards,

How to pass date as a variable in sql query execution in workflow

Help

mounikapolsani (mounikapolsani) February 26, 2019, 9:31am 2

@Lucas.Pimenta

Hi Lucas,

Could you please help with this issue.

Thanks,
Mounika

Run query: ORA-00936: missing expression

Topic		Replies	Views
SQL Query with Variables Help database , activities , question	8	2087	February 9, 2020
Run query: ORA-00936: missing expression Activities database , activities	15	3198	May 16, 2022
Pass a Variable into SQL Query on Execute Query Activity? Studio	7	2284	April 10, 2020
Trying to pass start date and end date variables into SQL query Studio datatable , excel , database , activities , question	11	10536	March 10, 2020
Update sql table with date format include Activities database , activities , question	10	3988	September 16, 2021

How to pass date as a variable in sql query execution in workflow

Related topics