I am trying to create a calculated field that calculates the days between today ( a constant) and the due date on a PO. I have used the Datediff function successfully before, but I am now having syntax issues. Can anyone help me fix this expression? I see plenty of posts on this particular problem but I still can’t identify where my syntax breaks down.
Take a look at the format returned by the PODetail.DueDate value. It might not be what the DATEDIFF function requires.
Just for fun (or troubleshooting), replace the PODetail.DueDate with ‘03/31/2018’ (including the single quotes), and see if you still get an error. If not, replace the Constants.Today with today’s date. I’ll bet one of those is what’s causing it to choke.