Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Possible bug in Data|Query Designer.

edited March 2011 in End User
Hi Guys,

Converting a query (Search) from date based to datetime based.

In the Query Designer I have added the field, set the Operator to
'Between' and put in "01/02/2009 00:00:00, 01/08/2009 23:59:59" for
Value. AutoSearch & Mandatory set to Yes.

The SQL shows..
"SELECT INVOICES.INVNUMB, INVOICES.MSN,
INVOICES.MODEL, INVOICES.QTY,
INVOICES.JOB_TYPE, INVOICES.JOB_STATUS,
INVOICES.HOURS, INVOICES.DATE_REP,
INVOICES.DATE_IN
FROM INVOICES INVOICES
WHERE ( INVOICES.JOB_STATUS <> 'CA' )
AND ( INVOICES.DATE_REP BETWEEN '2009-02-01 00:00:00' AND
'2009-08-01 23:59:59' )
ORDER BY INVOICES.JOB_TYPE"

Which is fine.

But when I look at the Search|Value again I only see ""01/02/2009,
01/08/2009 23:59:59"

The query does work correctly.

Is what I am seeing in Value correct?

Regards & TIA,

Ian

Comments

This discussion has been closed.