Datto Autotask PSA: Export generates reports with different date formats

Follow

Issue

When you export reports in Autotask PSA, the date is formatted in the European format in some columns and the US format in others.

Environment

  • Datto Autotask PSA

Cause

The date's display format is being controlled by the third-party application used to open the export, and the resource and the computer's environmental date formats are not aligned.

Resolution

We highly recommend that the resource and the computer's environmental date format be the same to avoid confusion.

Can I force the dates in Excel to mimic what I have configured in Autotask?

You cannot force the dates in Excel to mimic your Autotask date configuration. In most cases, the application that is opening the exported file is responsible for interpreting the date format. Some applications, such as Excel, use the local computer's preferences to set the format in the report.


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Community Forum or get live help.

For more Business Management resources, see the Datto RMM Online Help and the Autotask PSA Online Help .

Datto Homepage