K kirky007 Registered User. Local time Today, 08:41 Joined Aug 22, 2005 Messages 24 Aug 22, 2005 #1 How do you filter the subform so that it only returns data regarding the current week ending and no data before this date. Many thanks, Andy
How do you filter the subform so that it only returns data regarding the current week ending and no data before this date. Many thanks, Andy
RuralGuy AWF VIP Local time Today, 01:41 Joined Jul 2, 2005 Messages 13,825 Aug 23, 2005 #2 Is this what you need? ThisWeekNextSunday = Date() + (7 - DatePart("w", Date(), 2, 1)) ThisWeekLastMonday = Date() - (DatePart("w", Date(), 2, 1)-1)
Is this what you need? ThisWeekNextSunday = Date() + (7 - DatePart("w", Date(), 2, 1)) ThisWeekLastMonday = Date() - (DatePart("w", Date(), 2, 1)-1)
