Forum Discussion

WallaceYeboah's avatar
WallaceYeboah
Qrew Member
5 years ago

Convert Duration to Numeric

Is it possible to convert a duration value to numeric?

I tried using the function ToNumber(DurationField) however I keep getting an error.

------------------------------
Wallace Yeboah
------------------------------
  • np,

    you need to use a function so Quick Base knows what units to convert into.

    you can use

    ToSeconds
    ToMinutes
    ToHours
    ToDays
    ToWeeks


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Wallace__DHS_Ye's avatar
      Wallace__DHS_Ye
      Qrew Trainee
      Ahh okay I'll try that out. Thanks Mark!


      ------------------------------
      Wallace (DHS)
      ------------------------------