How to change a date format (receiving from the Hub a date type parameter)

Posted over 2 years ago by Emma Camacho

Post a topic
Emma Camacho
Emma Camacho Admin

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

Sorted by
Emma Camacho

Emma Camacho posted 6 months 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

J

Jason Ola posted 6 months 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