Question

Date Search over association not reliable

0

Hello, I've found that in a Data Grid where one of the search parameters is a date over an association, the search results are unreliable. Sometimes the results will be for the day after and sometimes they match the date searched. Has anyone else found this?

asked 2017-04-08

Jonathan Foucheaux

2 answers

Allard Brand · Answer 1 · 2017-04-10

Are you using any default value for the date search parameter? Using current date/time instead of begin of current day could cause this behavior.

Eric Tieniber · Answer 2 · 2017-04-10

Does this attribute have the "localize" option turned on or off? It should be off for DateTime attributes that don't use a time component.

If it's already turned off, check to see if you use any date math functions in microflows. For example, there are 2 functions to add days:

When you are operating on non-localized DateTimes, you should use the UTC functions. Not doing so can cause incorrect time zone adjustments to be applied.