Convert Duration to Numeric

Question

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
------------------------------

markshnier__you · Answer

np,you need to use a function so Quick Base knows what units to convert into.you can useToSecondsToMinutesToHoursToDaysToWeeks------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

wallace__dhs_ye · Answer

Ahh okay I'll try that out. Thanks Mark!------------------------------Wallace (DHS)------------------------------

Forum Discussion

Convert Duration to Numeric

2 Replies

Related Content

Create a formula duration over 5 years

Duration Fields with Pipelines

Convert yes/no multiple choice to numerical value?

Convert Numeric Fields to Birth Date

Convert Numeric field into Duration

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting