CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Range of Date Filter Problem

Print topic Send  topic

Author Message
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.

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.