2. ASPRunnerPro General questions
  3. Webreports Where Section Question
This topic is locked

Webreports Where Section Question

 		10/9/2011 4:29:17 PM
ASPRunnerPro General questions
author

In the webreports "Where" section using either an "or" or a "and" statement, I cannot seem to go between date values. I am using ASPRunnerPro 6.3 build 7474 with webreports in a SQL server database. The field in SQL I am using is "datetime" field. ASPRunner only inputs the date in this manner "01/01/2011".
I am essentially trying to build a report that has a where statement that retrieves data that is between 01/01/2004 and 12/31/2004.
I use the date field and have tried following:
>01012004

and

<01012005
>01012004 or <01012005
Are there any other ways that I may try?
Thanks in advanced.

Joe
Sergey Kornilov admin 10/9/2011

Correct date format is yyyy-mm-dd (that's how it's stored in the database).
>'2011-10-07'
1312 10/12/2011

I have tried using >'2011-10-01' and >2011-10-01 neither works in the Webreports to show entries that are from 10-01-2011 to now. I have looked in the manual and it confirms the second example above but it will not work. Any other suggestions?

Thanks,

Joe
Sergey Kornilov admin 10/13/2011

It might have something to do with the way date values are stored in your database. I think you need to show us your project and data. Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.