Forum Discussion

RussellHanson's avatar
RussellHanson
Qrew Trainee
4 years ago

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
------------------------------
  • 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
    ------------------------------
  • 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
    ------------------------------
    • RussellHanson's avatar
      RussellHanson
      Qrew Trainee
      Man, I wasted a lot of time on this one lol. Thanks sir!

      ------------------------------
      Russell Hanson
      ------------------------------