formula problems calculating days between two date fields
Hello,
I am having issues calculating days between two custom date fields.
SQL and MQL are date fields I created in the Account module.
MQL is filled in first, and after a few weeks SQL date is filled.
I'm trying to create a formula field that calculates the days in between.
With these formulas, I keep running into problems.
With this formula, I get a Syntax Error
((${Accounts.SQL}-${Accounts.MQL})/(1000*60*60*24))
With this formula, I don't get an error, but at the account, when I fill the dates in, the formula field value is a constant 0
((${Accounts.SQL}-${Accounts.MQL})/(1000*60*60*24))
What am I doing wrong?
Thank you!