Dates, CTOD, RIPARAM, America!

[Nick_Gale_(Guest)]

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!!!____

[kfleming]

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

[Nick_Gale_(Guest)]

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.