Community Chat

last person joined: 4 hours ago 

Chat, tips, and news from the Blue Prism Community
Expand all | Collapse all

How to Update Date Value as Null

  • 1.  How to Update Date Value as Null

    Posted 11-26-2020 10:16
    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
    ------------------------------


  • 2.  RE: How to Update Date Value as Null

    Posted 11-27-2020 09:24
    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
    ------------------------------



  • 3.  RE: How to Update Date Value as Null

    Posted 11-27-2020 10:52
    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
    ------------------------------



  • 4.  RE: How to Update Date Value as Null

    Posted 11-30-2020 05:13
    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
    ------------------------------



Share