Fridays

[mr moe]

I have a table that I imported from excel. It has start date, start time, end date end date. I did the datediff function to get the number of hours took, for exampel I wanted a report to show if the start and end date took more than 24 hours, but the problem is that I have some dates that started on friday therefore moset of them too like 72 hours since that saturday and friday shouldn't be counted. Is there a way I could filer for firdays and put a different criteria for them. I want my qry to do the followings:
Give me all items that too more than 24 hours. but if it's friday give me the ones that too 72 hours. Thanks guys.

 

[ezfriend]

If you have the date range (start - stop date) you can check to see if your start date is Friday [ Weekday(your_start_date) ] or not. If it is Friday, you'll know that this will take you 72 hours to run.