counting days

[d3pl0y3d]

Basically, I have two colums with dates. A from date, and a to date. I'm just tryin to make the next colum count the ammount of days from the from date to the to date. It has to count the actual day it starts and ends too though, so whatever it comes up with will probably have to have 1 day added to it. so if I'm taking from the 23rd to the 25th, that's 3 days, not 2. I'm pretty sure most formulas or tracking systems that people use would count it as 2. I hope I'm expressing what I'm trying to do in a way that is understandable.

[pbaldy]

You can use the DateDiff() function to count the days, adding 1 if necessary. More info on that function in Help.

[RuralGuy]

Have you tried the DateDiff() function yet?

[d3pl0y3d]

It comes up looking like this: DateDiff («interval», «date1», «date2», «firstweekday», «firstweek») I don't know how to write it though. interval needs to be by days, but when I replace it with d or (d), it says it doesn't recognize that field.

[RuralGuy]

DateDiff("d", Now, TheDate)

[d3pl0y3d]

type mismatch in the default value??

[RuralGuy]

Are your two fields DateTime DataTypes? What are their names? Show us what you have.

[d3pl0y3d]

ok, got it past that message, now it's saying it doesn't recognize the field "From" in a valid expression, or the default value in the table "Cadre Leave"

the two fields are From and To, they're both date/time types the table is named Cadre Leave.
I'm entering DateDiff("d",From,To) into default value, it turns it into DateDiff("d",[From],[To]) when I go to save it, I get the message I mentioned at the start of this reply

[d3pl0y3d]

The field that it's going into is labeled Days, and I have it as a number type field

[RuralGuy]

You should *always* adjust your names to not conflict with RESERVED words. They can cause you no end of grief. http://www.allenbrowne.com/AppIssueBadWord.html#F

[d3pl0y3d]

Changed them to From - Sign out, To - Sign in, Days - Total... same thing, except it says Sign out in the message now instead of From

[RuralGuy]

You should also not embed spaces in any names. I use CamelFontNames for clarification. Where are you putting this code? On a form? In a query?

[d3pl0y3d]

I'm putting it in default value in the field property for a column in a database table

[RuralGuy]

I don't think that will work and calculated fields should be in queries and not tables.