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?
Solved
Calculating number of days between two date fields
+4Best answer by MarkShnierYou
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])
+24np!
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])
+4Ok, 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!
+24Quickbase isn't hard, but you do need to stub your toe on about 1,000 easy things once.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.