transactedBeforeDate and transactedAfterDate

Rob McCann's Avatar

Rob McCann

30 Jan, 2015 07:41 PM

Hey :)

If I search with transactedAfterDate = 2014-01-01, does it include people who transacted at any time on 2014-01-01 too?

If I search with transactedBeforeDate = 2014-01-01, does it include people who transacted at any time on 2014-01-01 too?

Thanks
Rob

  1. Support Staff 1 Posted by Marc Guyer on 30 Jan, 2015 07:53 PM

    Marc Guyer's Avatar

    The way that the param names read are the way they work, if you think of the date starting at the beginning of a day. So after a day, is after the start of the day, and before a day is before that day begins.

    In other words, 2015-01-01 - 2015-01-01 would be an empty search. To search everything that occurred on the 1st, you'd want 2015-01-01 - 2015-01-02.

    Also, keep in mind that the authenticated user's timezone is used to determine the range. A user set to timezone X would potentially get a different result than a user with a setting of timezone Y.

  2. Marc Guyer closed this discussion on 30 Jan, 2015 07:53 PM.

  3. Rob McCann re-opened this discussion on 02 Feb, 2015 02:11 PM

  4. 2 Posted by Rob McCann on 02 Feb, 2015 02:11 PM

    Rob McCann's Avatar

    Hi Marc,

    That's perfect - thanks for the explanation :)

    Rob

  5. 3 Posted by Rob McCann on 02 Feb, 2015 02:14 PM

    Rob McCann's Avatar

    Just to confirm the following is true:

    2015-01-01 00:00:00 <= transaction < 2015-01-02 00:00:00

  6. Support Staff 4 Posted by Marc Guyer on 02 Feb, 2015 03:10 PM

    Marc Guyer's Avatar

    That's exactly correct.

  7. Marcela Poffald closed this discussion on 11 Apr, 2018 03:57 PM.

Discussions are closed to public comments.
If you need help with Cheddar please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

28 Mar, 2024 10:45 PM
24 Jan, 2024 08:33 AM
11 Jan, 2024 07:13 AM
30 Nov, 2023 02:07 AM
22 Nov, 2023 08:41 AM