Getting Started

 View Only
  • 1.  Get the Today() function into Date/Time Format

    Posted 06-07-2021 16:59
    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 06-07-2021 17:03
    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 06-07-2021 17:08
    Man, I wasted a lot of time on this one lol. Thanks sir!

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