ISTech Support Forum - INVTXN Date Field Question

Welcome, Guest. Please Login.

	05/13/25 at 13:43:03 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›

Pages: 1

INVTXN Date Field Question (Read 418 times)

stew

Browser

Semper Fi

Posts: 36
Gender: male

INVTXN Date Field Question
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

EVO 9/27/07 update applied
Client/Server Win2003 Server
Pervasive SQL 2000i SP3

IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: INVTXN Date Field Question Reply #1 - 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'})
Back to top	IP Logged

stew Browser Semper Fi Posts: 36 Gender:	Re: INVTXN Date Field Question Reply #2 - 08/21/07 at 11:32:12 I figured it out.......bad join on my part.
Back to top	EVO 9/27/07 update applied Client/Server Win2003 Server Pervasive SQL 2000i SP3 IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›