D dgaller Registered User. Local time Today, 16:38 Joined Oct 31, 2007 Messages 60 Nov 19, 2007 #1 I am struggling with a filter I thought would be simple. I have a field called close time and I want a filter that will show a record one hour before the close time?
I am struggling with a filter I thought would be simple. I have a field called close time and I want a filter that will show a record one hour before the close time?
neileg AWF VIP Local time Today, 21:38 Joined Dec 4, 2002 Messages 5,970 Nov 19, 2007 #2 DateAdd("h",-1,[Close Time]) will return a time one hour less than Close Time so you can test with that.
DateAdd("h",-1,[Close Time]) will return a time one hour less than Close Time so you can test with that.
D dgaller Registered User. Local time Today, 16:38 Joined Oct 31, 2007 Messages 60 Nov 19, 2007 #3 That worked. Thanks
