Attempting to query on date range returning out of range records

NMacAsp · ‎March 17, 2022

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.

Rasa-LilaM · ‎March 17, 2022

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:

Enter this link in your browser: https://help.developer.intuit.com/s/
Click the Sign in menu in the upper right to open the Intuit Developer Support Community login.
From there, choose Sign In or Create Account.
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

Rasa-LilaM · ‎March 17, 2022

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:

Enter this link in your browser: https://help.developer.intuit.com/s/
Click the Sign in menu in the upper right to open the Intuit Developer Support Community login.
From there, choose Sign In or Create Account.
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.

Topics

Training

Community

Resources

Attempting to query on date range returning out of range records

Attempting to query on date range returning out of range records

Attempting to query on date range returning out of range records

Need to get in touch?