How to have the same format for dates?

Question

When I try to export in excel a list of incidents from HPSM I have an issue; the date has different formats: "dd/mm/yyyy hh:mm" or "mm/dd/yyyy hh:mm:ss". It is a problem because when the day and the month are both less the 12th then I don't know which is month or which is day. Is it a possibility to have the same format or to create a program to do this?

Answer 1

I don't know HP Service Manager, but please consider exporting the data into two different files, one for each date setting, as CSV or Excel.

Then you can use tools like Power Query or the Text Import Wizard to open the files and set the origin date format of the column. Excel will then show that date column in your PC's regional settings format.