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;
How to change date formats in reports
-
- Posts: 74
- Joined: Fri Apr 02, 2010 2:26 pm
Re: How to change date formats in reports
Any help on this guyz?
Re: How to change date formats in reports
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.
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.
Cheers,
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: How to change date formats in reports
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.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
-
- Posts: 74
- Joined: Fri Apr 02, 2010 2:26 pm
Re: How to change date formats in reports
Thanks for your replies, how can I change it through the code? Which form?
Please advise..
Please advise..