cancel
Showing results for 
Search instead for 
Did you mean: 
NMacAsp
Level 1

Attempting to query on date range returning out of range records

I am attempting to retrieve entities through the Intuit SDK (.NET). I am using the following where clause example in my query:

 

WHERE MetaData.LastUpdatedTime >= '2022-02-15T08:30:46Z' AND MetaData.LastUpdatedTime <= '2022-03-14T23:59:59Z'

 

This returns records with the following LastUpdatedTime values on my records:

{2/15/2022 8:30:39 AM}
{2/15/2022 8:30:40 AM}
{2/15/2022 8:30:40 AM}
{2/15/2022 8:30:40 AM}
{2/15/2022 8:30:41 AM}
{2/15/2022 8:30:41 AM}


Is there a reason that the records I am getting back have LastUpdatedTime values that are out of my specified range? I am theorizing at this point two different possibilities:
1) I am formatting my dates incorrectly
2) Intuit drops the seconds value and only compares hours and minutes when looking at dates

Any help is appreciated as I am feeling a bit stuck with this.

Solved
Best answer March 17, 2022

Best Answers
Rasa-LilaM
QuickBooks Team

Attempting to query on date range returning out of range records

Thank you for visiting the Community today, NMacAsp.


I’m here to help ensure your concern about the date pulled up from your query is properly addressed.


We have a specific team that handles issues such as application errors and software integration concerns. I recommend posting this question to our Intuit Developer Forum. They have developer tools and resources available to assist with getting the time values to show in the correct range.

 

Here’s how to reach them:

 

  1. Enter this link in your browser: https://help.developer.intuit.com/s/
  2. Click the Sign in menu in the upper right to open the Intuit Developer Support Community login.
  3. From there, choose Sign In or Create Account.
  4. Follow the on-screen instructions to complete the process.

 

To help you in the future, I’m adding a link where you can access our self-help articles: QuickBooks Online guide. These resources contain topics that will guide you on how to efficiently handle your taxes, payroll, account information, banking tasks, sales or expenses related-activities, and so on.


Feel free to visit the Community again if you have other QuickBooks concerns. I’ll get back to assist further. Have a good one and stay safe.

View solution in original post

1 Comment 1
Rasa-LilaM
QuickBooks Team

Attempting to query on date range returning out of range records

Thank you for visiting the Community today, NMacAsp.


I’m here to help ensure your concern about the date pulled up from your query is properly addressed.


We have a specific team that handles issues such as application errors and software integration concerns. I recommend posting this question to our Intuit Developer Forum. They have developer tools and resources available to assist with getting the time values to show in the correct range.

 

Here’s how to reach them:

 

  1. Enter this link in your browser: https://help.developer.intuit.com/s/
  2. Click the Sign in menu in the upper right to open the Intuit Developer Support Community login.
  3. From there, choose Sign In or Create Account.
  4. Follow the on-screen instructions to complete the process.

 

To help you in the future, I’m adding a link where you can access our self-help articles: QuickBooks Online guide. These resources contain topics that will guide you on how to efficiently handle your taxes, payroll, account information, banking tasks, sales or expenses related-activities, and so on.


Feel free to visit the Community again if you have other QuickBooks concerns. I’ll get back to assist further. Have a good one and stay safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us