davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
I have a Input box as follows:
Date End = Input Box("Enter Date")
On column C, I want to filter everything that is greater than "Date End" - 45
So If someone entered 09/30/06 in the input box for Date End, I want my filter to be 08/16/06 and up. I want the 45 day date range on my filter. So my filter would have to read --Anything greater than "Date End" - 45. The following week, my Date End would change and then I'd have to filter for everything above Date End - 45. Thanks in advance.
Date End = Input Box("Enter Date")
On column C, I want to filter everything that is greater than "Date End" - 45
So If someone entered 09/30/06 in the input box for Date End, I want my filter to be 08/16/06 and up. I want the 45 day date range on my filter. So my filter would have to read --Anything greater than "Date End" - 45. The following week, my Date End would change and then I'd have to filter for everything above Date End - 45. Thanks in advance.
