How to Update Date Value as Null

[Yeswa_Vaibhav_1]

Hi All,

How to update the Stored Procedure using "Data - SQL Server" VBO, "Get Collection" Action.
As I am passing the variables as per the syntax, but how to pass the Date value as empty, so that inside the stored procedure Date field will be left as Null without updating with dummy value.

Is it possible to update the Date field as empty or not using Data - SQL Server VBO? If yes, please let me know how.

Thanks in advance.

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------

[John__Carter]

Try a query that treats the date as text and use ISNULL to return an empty string if the date is null.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[Yeswa_Vaibhav_1]

Hi John,

Please let me know if I missed the flow, But we should pass a date value to stored procedure an input, so that it will update in DB table (where Date field is date format).
Could you explain me a little brief.

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------

[John__Carter]

Hi the Get Collection action asks for an SQL statement as input, with the expectation that the query will return a set of results to be output as a BP collection. So as long as the SQL is valid (eg YourProc @Startdate='20200101', @EndDate='20201231') then it should work.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------