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

aswinb over 11 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

0 Ricardo Galvan
Appian Employee
over 11 years ago

When you say “data that was created in March” does this mean data from the 31st of March or does it show earlier dates too? Does this happen also when retrieving data having both past (or future) dates and not having one and one? Which Appian version are you using?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aswinb over 11 years ago

When I supply dates April 1st and April 30th it is showing me data captured in March end like say March 31st or 30th.....I don't know why this is happening as I didn't supply a -1 or -2 anywhere....I am currently using appian 7.4...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bharathwajanr587 over 11 years ago

Please check your appian user timezone with the database timezone..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aswinb over 11 years ago

the datetext function somehow seems to swallow the last value....for example if supply date values of 5/31/2014, 5/31/2014, 6/1/2014....it just outputs May 2014, May 2014...it doesn't take into account the 6th month...don't know why this is happening
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 11 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