I have a query rule that displays data that was created between two dates. For i

aswinb over 10 years ago

I have a query rule that displays data that was created between two dates. For instance if is supply April 3rd 2014 and april 30th 2014, it will display stuff that was created between those dates. But if I supply April 1st and April 30th it will display data that was created in march as well. Don't know why this is happening. Any clues?...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If I understand correctly, you are using the datetext function as part of the values passed to the expression?

If you, remember that the datetext expects values in gmt so you may need to wrap the values in the gmt() function inside datetext()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If I understand correctly, you are using the datetext function as part of the values passed to the expression?

If you, remember that the datetext expects values in gmt so you may need to wrap the values in the gmt() function inside datetext()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data