I am trying to determine how many days have elapsed since an order was placed.
I am using a Formula (numeric) field to do the calculation, and setting the formula to this: {today}-{trandate}
I expected to get a nice round integer, like 3, but instead I get 3.55820601851851851851851851851851851852
I can clearly round my results down to solve the problem. Is that the cleanest way to solve the problem? I'm looking for a durable solution that would solve for daylight savings time changes, etc.