2. PHPRunner General questions
  3. Date span issue
This topic is locked

Date span issue

 		9/8/2010 2:39:44 PM
PHPRunner General questions
swant author

Im trying to create a report based on date span and i cannot get the correct syntax and make it work correct, so i just want to build a report based on lets say 2010-08-01 to 2010-08-31, im assuming i add it to the filter section in my query designer but i cannot get the correct syntax, ive looked on several different sites but cannot figure it out. I've also modified it in the sql tab as well. any tips would be great.
A
 		ann 9/9/2010

Hi,
could you clarify what kind of database do you have?
swant author 9/14/2010

Sorry it is a mysql



Hi,
could you clarify what kind of database do you have?
A
 		ann 9/15/2010

Here is a sample code for MySQL (Edit SQL query tab):

select

DateField,

...

from TableName

where DateField between '2010-08-01' and '2010-08-31'