I have a display screen that i want to show transactions that are between two dates(Field ID's Date1,Date2), however i cannot get it to work. The selection criteria is as follows:
Code: Select all
YTDC='C' AND YDATE >=? AND YDATE <=?
Code: Select all
parameter value: script: "1" + get("Date1").substr(6,2) + get("Date1").substr(0,2) + get("Date1").substr(3,2);
parameter value 2: script: "1" + get("Date2").substr(6,2) + get("Date2").substr(0,2) + get("Date2").substr(3,2);
Code: Select all
applyProperty("Grid1", "parameter value", "1" + get("Date1").substr(6,2) + get("Date1").substr(0,2) + get("Date1").substr(3,2));
applyProperty("Grid1", "parameter value 2", "1" + get("Date2").substr(6,2) + get("Date2").substr(0,2) + get("Date2").substr(3,2));
applyProperty("Grid1", "field type", "grid");
getObj("Grid1").grid.refresh();
getObj("Grid1").grid.render();
Thanks for your help