Thread: datediff
View Single Post
  #1 (permalink)  
Old July 27th, 2006, 03:03 PM
ebburks ebburks is offline
Authorized User
 
Join Date: May 2006
Location: Elk Grove, CA, USA.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default datediff

Hi
I am using the datediff to get the difference between two days from two form control fields.
I have setup one table that I have enter dates from 1/01/2006 to 12/31/2006. I have made a query that omits holidays and weekends and assigned them to each one of the form control fields. However when I use the datediff function to show the day difference from the two diff dates selected in each field it is still including weekends and holidays in the date difference. How do I get it to just give me the difference between the days in the query?

EB
__________________
EB