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 gridif from and to dates are 23/06/2015 & 24/06/2015 - rows containing 23/06/2015 are shown in the gridif ...
OriginalPostID-153990
Discussion posts and replies are publicly visible