2 Replies Latest reply on Aug 8, 2016 10:52 AM by yashwanth nekirikanti

    Need to increment date by one day but the problem is

    yashwanth nekirikanti

      I have "Renewal Start Date"  as 1/1/2015 and "Renewal End Date"  as 12/31/9999. I need to create Date field "Renewal new Start date" which is  "Renewal End Date"+1

       

      I used below formulae to create date field

      date(dateadd('day', 1, [Renewal End Date]))

       

      But If i dont exclude End Date 12/31/9999. I'm getting this error "Database error 0x80040E14: Invalid procedure call"

       

       

      Can someone help me with this

       

       

      Thanks in Advance

      Yash