I am trying to create a calculated column (whole number) in my Table that will calculate the number of days between Today/Now and another field (Application Sent). This field is currently set for a Date Only value, and the Time Zone Adjustment is set to Date Only.
I can't do Time Zone Adjustment or Local Time because I have Users across the country working in the same system, and they can't be seeing different dates.
How do I create a calculated field to determine this difference in days? It seems that it only works with fields set for Local User or Time Zone Independent, which doesn't work for me. I've tried creating additional calculated columns, but nothing seems to be working. Any recommendations?
