RoundUp Function

[softball21]

I am trying to use the round up function and i keep getting an error. I am trying to subtract place date from todays date divide by seven to find out how many weeks rounded to even number. Example
WeeksOld:=Roundup(Date()-[PlaceDate]/7,0)
If the answer is 57 days which is 8.1428 weeks I want it to round up to 9 weeks. When I try to run the query an error box pops up saying "Undefined function "Roundup" in Expression". Can you tell me if I am using roundup in the wrong way.
Thanks

 

[PHV]

Have you tried something like this ?
WeeksOld:=(Date()-[PlaceDate]+6)\7

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244