How to change date formats in reports

For users or potential users.
Post Reply
alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

How to change date formats in reports

Post by alhalwachi » Mon Jul 04, 2011 10:03 am

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
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Re: How to change date formats in reports

Post by alhalwachi » Tue Jul 12, 2011 2:53 am

Any help on this guyz?

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: How to change date formats in reports

Post by wjstarck » Tue Jul 12, 2011 3:54 am

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.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: How to change date formats in reports

Post by jordansparks » Tue Jul 12, 2011 5:54 am

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

alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Re: How to change date formats in reports

Post by alhalwachi » Tue Jul 12, 2011 12:34 pm

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

Post Reply