I am getting back whole numbers for days and I want 2 decimals instead. I created a Today field based off days but can't use with a Date/Time field without converting that field with ToDate, giving me only the whole numbers as mentioned.
Is there any way to convert Today (either just using the Today function or the Today field) to Date/Time so I can get more accurate results? Even if Today() defaults to something like 6/7/2021 00:00? That way I at least can get the difference of the time/hours into decimals for my other field.
Maybe I am going about this entirely the wrong way. Below is the basic premise for what I am trying to get, which is aging ticket time. So instead of a rounded number like 10 days, I want something like 9.53 days.
------------------------------
Russell Hanson
------------------------------