Hello guys I’m not able to use my datetime type variable in the query. The variable ‘DateCurrent’ = DateTime.Now.ToString(“dd/MM/yyyy”) [2022-12-21] [2022-12-21 (1)]

@Luca2 The string output should match exactly with the format in db If in db you have 12-12-2022 then you have to give the same Cheers

Cant using datetime in database query

Luca2 (Luca) December 21, 2022, 4:28pm 4

“data_de_execucao” DATE NOT NULL

but what do i do now?
I don’t understand why RPA says there was a failure in the conversion to string if I already converted

Topic		Replies	Views
Sql query with between, And command Studio database , activities , question	12	2331	March 10, 2020
How to insert datetime in sql query by now.tostring Studio studio , question , tools	2	2450	March 4, 2021
Using DateTime in Execute Query causes error Activities database , sql	0	1309	February 15, 2021
Datetime type conversion issue Help database , studio , question	7	1069	January 28, 2020
How to update current system date & time into Database Studio database , activities , question	6	4989	March 6, 2020