Date subtraction

[Krash878]

Can a Date be subtracted from another date?

I have to keep track of how many days we are working on something and then bill accordingly. The billing fomula is

Rate= 6/365
Rate X Amnt X Actual Days

So if I have an item that was $100.00
And I recieved it on 06/14/01 and finished it on 06/26/01

6/365 X $100.00 X 12 = $19.72

Can dates be subtracted to give me a number

Thanks
Kenny

 

[nickjar2]

Yes.

Use dateDiff

to get the number of days use:

dim i as integer

i = datediff("d",startdate,enddate)

Nick

 

[JoeMiller]

You can also do just a regular subtraction of the dates by doing the following:

#1/3/01/#-#1/1/01#

That would result in 2.

HTH Joe Miller
joe.miller@flotech.net

 

[Krash878]

DateDif worked I was using it in a query
Thanks
Kenny

 

[Krash878]

Arg I forgot a question
The Formula
Rate= 6/365
Rate X Amnt X Actual Days

I have the days part how do I multiply the feilds in the query or on a form

Thanks

 

[tlbroadbent]

Use the * as the multiplication operator.

Rate * Amnt * [Actual Days]
Terry

http://members.home.net/tlbroadbent/prog.htm

"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes