RussellHanson
4 years agoQrew Trainee
Get the Today() function into Date/Time Format
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
------------------------------
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
------------------------------
- The function
Now()
is similar to Today() but its returns a date/ time field type.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------