I have a view built and I would like to add a column to my view to calculate the days in Que.
ModifiedDate_Disp (is the first date)
Today_disp (is the second date).
I’m having trouble with the formula, I can’t seem to get any I try to work.
Subject: Column formula
Assuming the field is date time format and not text (hopefully)
Try this?
(ModifiedDate_Disp - Today_disp / 86400) + " days"
Subject: What have you tried so far?
It seems you are using date type field. What have you tried so far? What happend and what did you expect?