topic RE: How to Update Date Value as Null in Product Forum

How to Update Date Value as Null

Yeswa_Vaibhav_1 — Thu, 26 Nov 2020 15:16:00 GMT

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
------------------------------

RE: How to Update Date Value as Null

John__Carter — Fri, 27 Nov 2020 14:24:00 GMT

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
------------------------------

RE: How to Update Date Value as Null

Yeswa_Vaibhav_1 — Fri, 27 Nov 2020 15:52:00 GMT

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
------------------------------

RE: How to Update Date Value as Null

John__Carter — Mon, 30 Nov 2020 10:13:00 GMT

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
------------------------------