3969488 Newbie

Thanks Jhelver, Also NS Support did come back to me, this is the code fyi. to_number((cast({custrecord_cmn_exit_time} as date) - {created}) * 1440)

Thanks Medel, This didn't work, probably because I'm trying to do a calculation of two fields (exit time - entry time) to get the duration. I did go further with your idea in principle, though by bringing a single field (TO_CHAR) onto a record via a workflow and then duplicating the value to a stored field. Unfortunately…

That would have been my first choice, but there's no join from Employee to call.activity for me to be able to do that unfortunately.