Datediff

CodeCharge Studio

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

Datediff

Author

Message

JoeBoy

Posted: 11/29/2004, 8:00 AM

Whats wrong in this:
(DATEDIFF(day, RefDate, {s_RefDate2}) >= 121)

I need the number of days between the Database field "RefDate" and the url parameter "RefDate2"

It works when I use:
(DATEDIFF(day, RefDate, {fn NOW() }) >= 121)

or if I use a specific date in this format #01/01/2000#

What Im doing wrong?
ASP, SQL

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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login