Update sql table with date format include

[prasath_S]

@li.yu yes you can set it as string and pass, think it will update in the SQL.

Please refer the link,

How to Remove timestamp from DateTime Variable

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 …

Thanks