I have a formula field and I want to get the difference in days from that day to the Invoice date. Any ideas? I keep getting an Error that is is expecting a date in the formula field.
Here is what I AM USING:
{View_test.InvoiceDate} - {@Promise Date}
I am trying to Compare 2 dates. If the first date is null then return the value of the second date; otherwise use the value from the first date. However, this does not seem to be working since I get a False instead of the date. Can someone please help?
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.