How to make this a numeric formula instead of duration

Question

Hello,
How can I make this a numeric formula instead&nbsp; of a duration?&nbsp;
Min([Weekending Date]-[Employee - Departure / Check out],7)
[Weekending Date]-[Employee - Departure / Check out} are both date fields&nbsp;
I want to show which ever is shorter in a numeric format. If I use days(7) I can get a duration of 7 days but I need to be able to add or subtract and multiply by this answer in other cells.&nbsp;

Thanks,&nbsp;
Tara------------------------------Tara Stroup------------------------------

markshnier__you · Answer

try this

Min(ToDays([Weekending Date]-[Employee - Departure / Check out]),7)

The bold part calculates the Duration, and then the ToDays function converts that span of time into a numeric number of days.&nbsp; So you will need to change the field type now to formula numeric.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

tarastroup · Answer

That worked great. One more question. In the situation where the Employee Departure date is past the weekending date, because we have already planned the departure for the next week the formula returns a negative number. Is there a way to add if - then 7?

Thanks,

Tara

------------------------------
Tara Stroup
------------------------------

Thanks,&nbsp;
Tara------------------------------Tara Stroup------------------------------

markshnier__you · Answer

Assuming that your stated logic is what you actually want, I like to use what are called formula variables.&nbsp; That just makes the formula easier to read and to debug.&nbsp; Keep in mind it may very well be you who has to look back at this formula a year from now and ask "what was I doing here?".

var number RawDays = Min(ToDays([Weekending Date]-[Employee - Departure / Check out]),7);
IF($RawDays &lt; 0, 7, $RawDays)

Here is a link to help on Formula variables.
https://help.quickbase.com/user-assistance/formula_variables.html
------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

tarastroup · Answer

That worked great. Thank you Mark!------------------------------Tara Stroup------------------------------

Forum Discussion

How to make this a numeric formula instead of duration

Related Content

Formula-Numeric Field Returning Null Instead of 0

Create a formula duration over 5 years

Duration Formula

Show Numeric Formula Field as Duration

IF statement changing numeric to text