Version 3.04.2510 SF Professional

Have a report against QW using the Created field to identofy range of dockets used.

If I use Created Between Date1 and Date2 (ask at runtime) it does not include records for Date1 and Date2 only what is netween Date1+1 and Date2-1

If I change to Created Greater than or equal to Date1 (ask at runtime) and Created Less than or equal to Date2 (ask at runtime)

Again it does not include records on Date1 or Date2.

How can I get around this.

This is because those date fields are actually stored as DateTime fields in the database but Stonefield Query displays them as just Date fields by default.

You can have Query display the Time by editing the field, going to the Format tab then unchecking "Use default format" and "Display date only".

Then when you filter on these fields you can include a Time as well as a Date.

In this case you will need to make your date range one date longer.

This is because Query uses a default of 12:00:00 AM for the Time portion of the filter.

For example if you filter on: CreateDate is between 01/01/2008 and 01/31/2008
this is actually sent to the DB engine as: CreateDate is between 01/01/2008 12:00:00 AM and 01/31/2008 12:00:00 AM

So anything after 12:00:00 AM on 01/31/2008 will not be included on the report.

In this case you would instead want your filter to be: CreateDate is between 01/01/2008 and 02/01/2008