Jan K. van Dalen
|
Posted: 12/24/2008, 11:13 AM |
|
Hi Everyone,
I'm having one of those brainfart moments.
Using 4.x with ASP.
I have a Search/Grid forms. The Search ask for a date which is pass to the
grid for filtering purposes. This works perfect.
Now I need to enhance the filter to return records that have a FieldDate
less than or equal the passed date via URL (s_EOW) and RecordDate greater
than or equal to (s_EOW MINUS 7 DAYS)
That will give me all records in the week ending on S_EOW.
Cannot compute the Beginning of Week correctly. I have tried expressions
using dateadd(), cdate() .... without result. If I use SQL it works fine but
want to use Table view.
Could you please assist me on this one?
Thank you.
|
|
|
|