Fridays

Mar 29, 2007

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.

View Replies


ADVERTISEMENT

Expression Help: Calculating Number Of Fridays Since A Certain Date

Feb 7, 2005

So I have a database of contacts, and it has their birthdays listed as well. What I need to do is calculate the number of Fridays from their birthday up until today's date. How do I do this? Thanks

View 2 Replies View Related

Forms :: Count No Of Days Excluding Fridays

Mar 11, 2014

i am trying to find the expression to count the number of days excluding fridays from a given txtStartDate and txtEndDate.

i've got the expression to count the number of days but i need omit the fridays from it.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved