Issue with query filter

I need to filter a date on Tempo report. That date is stored as Text in the database.
When i place a 'From' and 'To' date fields in the filters and write the following query filter on the above mentioned field,
it is not working property. rdateFrom & rdateTo are the date input fields placed on the report. requestSubmittedDate is varchar field in database. Storing appian datetime variable into this.
if(or( rule!APN_isBlank(ri!rdateFrom), ri!rdateFrom = "", rule!APN_isBlank(ri!rdateTo), ri!rdateTo = "") ,{},
'type!{www.appian.com/.../2009}QueryFilter'(
field: "requestSubmittedDate",
operator: "between",
value: {ri!rdateFrom, rdateTo}
)
)
if from and to dates are 23/06/2015 & 23/06/2015 - no rows are shown in the grid
if from and to dates are 23/06/2015 & 24/06/2015 - rows containing 23/06/2015 are shown in the grid
if ...

OriginalPostID-153990

OriginalPostID-153990

  Discussion posts and replies are publicly visible

Parents
  • ...from and to dates are 23/06/2015 & 25/06/2015 - rows containing 23/06/2015, 24/06/2015 & 25/06/2015 are shown
    if from and to dates are 23/06/2015 & 26/06/2015 - all the above rows along with 26/05/2015 is also shown

    -> When i try converting the text with toDate or toDateTime in value or at the ruleinput for requestSubmittedDate, total filter is not working.
    -> When i keep only one date field and use 'includes' operator, it is working good for the single date filter.

    Please let me know how to get the filter on 2 dates?
Reply
  • ...from and to dates are 23/06/2015 & 25/06/2015 - rows containing 23/06/2015, 24/06/2015 & 25/06/2015 are shown
    if from and to dates are 23/06/2015 & 26/06/2015 - all the above rows along with 26/05/2015 is also shown

    -> When i try converting the text with toDate or toDateTime in value or at the ruleinput for requestSubmittedDate, total filter is not working.
    -> When i keep only one date field and use 'includes' operator, it is working good for the single date filter.

    Please let me know how to get the filter on 2 dates?
Children
No Data