Liveware Publishing Support Forum

I am using a control file to run various reports, where users enter date variables (named datelow and dateupp) which are then compared against a datetime field in the database...____To convert the database field I use TODATE(fieldname)__For the user inputs CTOD(RIPARAM(^datelow^) and similar for dateupp____In the filter I have the database field greater than or equal to datelow, and less than or equal to dateupp. Fine...____Most of the reports are ok, BUT there is one that insists on altering the user input of dd/mm/yyyy to mm/dd/yyyy before passing through to Arpeggio.____As far as I can see, the reports are virtually identical.____Help!!!____

If you open Arpeggio designer and print the Report Specification for the good and bad reports, on the last page you will see the date format that the report contains.__My guess is that the bad guy is different than the good guy.____To change the bad one, you need to open the report in the designer and then open the windows control panel and go the the date format.__If the current control panel is set the way you want, then you need to select something different and then re-select the one you want. If the original was incorrect, the select the correct. This should enable the Apply button which you can then click.__When you return to the report, it will have inherited the applied settings. You can then save the report.____A bit of a roundabout but it should work for you.____Kathleen__R&R Support

Thanks Kathleen,____Solved it in an instant. I can^t believe I^ve been working with Arpeggio.RnR for 4 years, and this is the first time I^ve come across this problem!____Thanks again,____Nick.