Getting Started

Expand all | Collapse all

Get the Today() function into Date/Time Format

Jump to Best Answer
  • 1.  Get the Today() function into Date/Time Format

    Posted 6 days ago
    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
    ------------------------------


  • 2.  RE: Get the Today() function into Date/Time Format
    Best Answer

    Posted 6 days ago
    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
    ------------------------------



  • 3.  RE: Get the Today() function into Date/Time Format

    Posted 6 days ago
    Man, I wasted a lot of time on this one lol. Thanks sir!

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