does anyone else have issues with trying to find t...
# generalc
Chris Rasmussen
10/27/2021, 4:26 PMdoes anyone else have issues with trying to find the difference between two dates in the system notes? The formula i have written doesnt have any errors but im not getting any results here is the formula (CASE WHEN {systemnotes.newvalue} LIKE 'QC Received' THEN {systemnotes.date} end)-(CASE WHEN {systemnotes.field} LIKE 'Document status' AND {systemnotes.oldvalue} LIKE 'Pending Refund' THEN {systemnotes.date} end)
g
Gregory Jones
10/27/2021, 4:50 PMHave you tried separating out the formulas into different columns and looking at the results? That could help narrow down what's causing the issue.
c
Chris Rasmussen
10/27/2021, 4:57 PMi did that and the formula's populated the dates that i needed but when combined into one column to calculate the difference in days i dont get any results
g
Gregory Jones
10/27/2021, 4:58 PMmaybe throw in an
else nullendGregory Jones
10/27/2021, 4:59 PMI seem to recall that being an issue for me in the past when i was trying to do date math.
3 Views