If your Qlik date field uses the format yyyy-MM-dd, but the Mail & Deploy Hub returns a date with the format dd.MM.yyyy HH:mm due to regional settings, the formats can appear inconsistent in reports.

To adjust the format, you can use the following expression:

DateTime.ParseExact([ReportParameter].[To], "dd.MM.yyyy HH:mm", Nothing).ToString("yyyy-MM-dd")

This expression parses the date using the dd.MM.yyyy HH:mm format and converts it into the desired yyyy-MM-dd format. The date format used in reports is determined by the regional settings of the service account running the Mail & Deploy server. Therefore, updating these regional settings on the server can also globally adjust the way dates are treated in Mail & Deploy.

Steps to Implement the Expression:

1. Where to Use This Expression:

   • This expression should be applied in the Mail & Deploy template editor. Specifically, you can insert it in the expression field for the relevant parameter or variable. For example, if a Qlik Sense field displays dates as 31.12.2023 but the generated report changes the format to 12/31/2023, applying this expression in the template editor ensures consistency.

2. Global Changes to Date Formats in Mail & Deploy:

   • If you want to globally change the way dates are handled, update the regional settings of the service account on the Mail & Deploy server. This change will affect all date fields in your reports. As noted by Emma Camacho, the date format will always align with the service account's regional settings on the server.