How to Remove timestamp from DateTime Variable

Help Activities
, , , , ,
5

Hi Rajesh,
I think you don’t need datetime variable in uipath to get data from sql query only date variable of type string will work.

you can pass string value to filter this for example your scenario

your query

UPDATE dbo.TableName
SET Column1=0
WHERE MemberID=‘xxxx/’ AND DateOfService=‘2021-05-22’

consider only this part of query

AND DateOfService=‘2021-05-22’

"AND DateOfService="+"'"+DateStringVariable+"'"

the above code you will use to filter data using execute non query activity in uipath. It will give you expected result.

2 Likes