End date is a SharpCloud specific property, that is calculated by performing “start + duration”. By default, when an item is created, its duration is 31 days.


Type of Data Returned


This function will return the end date, based upon the start + duration.




Returning the date 2 months after the expected end date






ADDDAYS(end, 60)


Calculating the date 1 month before the end date


ADDDAYS(end, -30)