Entries

Due Date

if(not empty(prop("Invoice Date")) and not empty(prop("Terms (Net)")), dateAdd(prop("Invoice Date"), toNumber(prop("Terms (Net)")), "days"), fromTimestamp(toNumber("")))

if(not empty(prop("Invoice Date")) and not empty(prop("Terms (Net)")),

Check to see if both Invoice Date and Terms (Net) are not empty.

dateAdd(prop("Invoice Date"), toNumber(prop("Terms (Net)")), "days"),

If they're not, take the select value from Terms (Net), convert it to a number, then add that number of days to Invoice Date.

fromTimestamp(toNumber("")))

If either Invoice Date or Terms (Net) are empty, display nothing.

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>