How to change date formats in reports

[alhalwachi]

Dear All

When retreiving reports, payments report for example, the format of the date is month/day/year, how can i change this to DD/MM/YYYY?

Thanks;

[alhalwachi]

Any help on this guyz?

[wjstarck]

Well, you can't, because those dates are hard-coded. So for now it would be a feature request to be able to have a different date format for Reports.

You would have to create a query (Reports > User Query) with the dates in the format you want and run that instead for all those reports you are interested in.

[jordansparks]

It's only that particular report that is a problem because we use RDL reporting. Yes, I think it's a feature request for now, or else you can just use queries instead.

[alhalwachi]

Thanks for your replies, how can I change it through the code? Which form?
Please advise..