Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Query based on Time Created ending date is not working properly. |
Author |
Message |
|
Posted : 2008-05-16 00:21:29 |
Hi,
I recently posted a thread and I was informed that TimeCreated uses Time stamp with date when executing with the query. When applied the filtered data received from Quickbooks also inculded information further from ending date.
DateFrom = format(Sheets("User").Range("I22").Value, "yyyy-mm-dd") 'April's date DateTill = format(Sheets("User").Range("I14").Value, "yyyy-mm-dd") ' May 15th, Today's date sSQL = "SELECT InvoiceLine.TxnDate, InvoiceLine.InvoiceLineItemRefFullName, InvoiceLine.InvoiceLineQuantity FROM InvoiceLine InvoiceLine WHERE (InvoiceLine.TimeCreated>={ts '" & DateFrom & " 00:00:00.000'} And InvoiceLine.TimeCreated<={ts '" & DateTill & " 00:00:00.000'}) ORDER BY InvoiceLine.TxnDate"
In theory it should work but the results also include entries up to 25th May.
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-16 12:10:16 |
TimeCreated is when the transaction was first created in QuickBooks and doesn't mean or imply the current TxnDate of the transaction. You should include the TimeCreated column in your query to better see what's going on. |
|
|
|
|
Posted : 2008-05-16 18:43:33 |
Makes a lot of sense. I will check it out.
Thanks! |
|
|
|
|