Skip to main content
Question

Convert Duration to Numeric

  • November 23, 2020
  • 0 replies
  • 547 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • November 23, 2020
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
------------------------------