How can I run a warranty report showing WarrantyExpiry dates on all resources?

Hi,

I am using build 7.5.0 Build 7504 on MSSQL.

I am trying to create a report for the following:

I want a list of all my resources (servers, printers, switches as well as all my custom resources such as UPS and backup devices) and their expiry dates.
I want the date formats to be in English "dd-mm-yyyy" format & not US format with time attached i.e. not 01-22-2009 00:00:00 (otherwise exports & sorting in Excel doesnt work).
Or, I'd at least like the report correctly ordered by "WarrantyExpiry" so I can focus on what I have to renew (I couldn't get the report to orderby this field correctly - which is why I have to export to Excel).
I dont want to use the field "resource.expirydate" as we don't use this field. We only use the "WarrantyExpiry" for all of our assets (why there are 2 different fields for the same data I am not sure?!?).

I've read a lot of similar posts to this one, and I've tried taking their SQL and editing it - but I still can't get the results I want.

Basically I just want to be able to run a monthly report of all my equipment ordered by the warranty expiry date so that I can decide what to do with it. Its kind of silly that we record warranty data for all our our key equipment in ServiceDesk - but we can't do anything with it.

Your help would be much appreciated.

Marc