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