We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
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")
0 Votes
2 Comments
Emma Camacho posted about 1 year ago Admin
Hi Jason,
The date format will be taken from the service account's regional settings in the M&D server.
kind regards, Emma
0 Votes
Jason Ola posted about 1 year ago
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 ?
0 Votes
Login or Sign up to post a comment