I am having a difficult time with a TextList object in PanX. I am converting a Pan6 file and I want to choose from records with a processing date greater than a specified time from today(). For example the list should contain all records within 3 months, 6 months, 1 year, etc before the current date. I have two lists on the page one selects the interval and creates a variable that specifies the date after which I want records to display. The variable is created and is correct. However, the larger Object that shows patient records is not displaying the records I want. The selection formula is shown here:
?(«ProcDate»≥ vDateRange,exportcell(«Name»)+tab()+exportcell(«MR»)+tab()+exportcell(«ProcDate»)+tab()+exportcell(«ProductSource»)+tab()+exportcell(«Procedure»)+tab()+exportcell(«RecordNo»),"")
«ProcDate» is a date field and displays on the list when all records are selected The variable vDateRange is a number that represents the date I want and can be converted to a date using datepattern. However, no records are selected.
I have tried a number of permutations such as date(vDateRange) or even Datepattern(vDateRange,“MM/DD/YY”) and nothing works. I can write a short procedure that works fine “select «ProcDate» => vDateRange” to physically select the records in the data sheet, just not in the TextListObject.
Help would be greatly appreciated.