ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> INVTXN Date Field Question
http://www.istechforum.com/YaBB.pl?num=1187629752

Message started by stew on 08/20/07 at 10:09:12

Title: INVTXN Date Field Question
Post by stew on 08/20/07 at 10:09:12

Can anyone tell me what is different about the INVTXN.MTIT.DATE field?

I have a SQL query I have written to pull usage data that seems to disregard any DATE filter I set on this field. No matter what the query pulls back ALL info regardless of the date range specified.

It is not the way the query is written. I can write a basic query and limit on a DATE field........just not this date field in this table.

Help

Title: Re: INVTXN Date Field Question
Post by GasGiant on 08/20/07 at 12:52:44

It works fine here if I format date as YYYY-MM-DD (e.g. WHERE invtxn_mtit_date > {d '2007-08-01'})

Title: Re: INVTXN Date Field Question
Post by stew on 08/21/07 at 11:32:12

I figured it out.......bad join on my part.