Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DateDiff Problems in Report
I am not a huge technical person but I looked at the formulas with http://www.pacificdb.com.au/MVP/Code/Dates.htm and here is what I came up with but isn't working =DateDiff("d",[Receipt Date],Date())-DateDiff("d",[Receipt Date],Date(),1) * 2 If(Date(), 1) = 7, If([Receipt Date], 1) = 7, 0...- s1345
- Post #4
- Forum: Microsoft: Access Reports
-
DateDiff Problems in Report
I have a report written that calculates the number of days from today compared to another date. I am having problems figuring out the criteria to successfully omit weekends. My formula in my Access Report is =DateDiff('d',[Receipt Date],Now()) where Receipt date is the date field I am...- s1345
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
