index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Problem with datediff :: (5)Post a New Message | Post a Reply
Jun 30 2005, 8:18 AM
 Problem with datediffPost a Reply
 jacobo

View this author's profile Send this author a private message

since: Jun 30, 2005
from: Panama, Central America

I'm trying to compare dates using datediff but I get no results....
I'm using version 2 and SQL server.  My command is as follow:

[sql] datediff(dd, start_date,getdate()) [/sql]

I'll apreciate guidance

Jacobo

Jun 30 2005, 9:45 AM
 Re: Problem with datediffPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

It lloks like a pretty valid statement. What version of SQL Server are you using?
Also make sure that you are using version 2.5.40 or greater of the report wizard.


-------------------------
Ghost
Jul 1 2005, 6:27 AM
 Re: Problem with datediffPost a Reply
 jacobo

View this author's profile Send this author a private message

since: Jun 30, 2005
from: Panama, Central America

I'm using MSSQL version 2000, I'm not quite sure aspreport version.....I download the free version from the site.....where can I check version??

Jul 1 2005, 6:50 AM
 Re: Problem with datediffPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Response.Write (objWiz.Version)


-------------------------
Ghost
Jul 1 2005, 8:14 AM
 Re: Problem with datediffPost a Reply
 jacobo

View this author's profile Send this author a private message

since: Jun 30, 2005
from: Panama, Central America

My current version is 2.0.540

Pages: (1)   [1]

search this forum: