If my Qlik date field has the following format "yyyy-MM-dd" and the hub is returning a date with this format "dd.MM.yyyy HH:mm" because of the regional settings.
You can use this expression to change the format:
DateTime.ParseExact([ReportParameter].[To], "dd.MM.yyyy HH:mm", Nothing).ToString("yyyy-MM-dd")
The date format will be taken from the service account's regional settings in the M&D server.
kind regards, Emma
Hello ! Where should I use this expression to change the format of a field ? I have a field in qliksense displaying dates as 31.12.2023 but when I do a report it changes the format to 12/31/2023. Or is there a way to globally change the way dates are treated in M&D ?