Forum Discussion

ChrisSwirtz1's avatar
ChrisSwirtz1
Qrew Trainee
15 hours ago
Solved

Calculating number of days between two date fields

This is probably a super easy question but I am rusty and nothing I am trying is working and all the discussions I am finding are asking for more complicated formulas.

I simply need to calculate the number of days between 2 date fields on a record?

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    15 hours ago

    np!

    Just make a formula numeric field with the formula

    [End Date] - [Start Date]

    If you want he  number of Business Days, then there is a function for that.

    WeekDaySub([End Date], [Start Date])

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    15 hours ago

    np!

    Just make a formula numeric field with the formula

    [End Date] - [Start Date]

    If you want he  number of Business Days, then there is a function for that.

    WeekDaySub([End Date], [Start Date])

  • ChrisSwirtz1's avatar
    ChrisSwirtz1
    Qrew Trainee
    15 hours ago

    Ok, I feel dumb... I swore I tried those very formulas and it didn't work, turns out it was because I accidently added one of the date fields as a text field and didn't realize it. Once I fixed that formula worked just fine, thanks!

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    15 hours ago

    Quickbase isn't hard, but you do need to stub your toe on about 1,000 easy things once.