How to change the Date format for all Date fields in Memory?
I load a qvd with multiple dates. All the dates have the Date Format DDMMMYYYY and are dual values. How can I change the date representation for all those dates to DD/MM/YYYY without writing code for each date individually or changing the date representation in document properties>number for each date individually?
I already found this solution. This is not what I'm looking for. I would like to change all the date formats for the date fields that are currently in memory without having to write code for each field individually. I need to load 50 tables and convert all the date fields. Because the data is read from qvds qlikview can already recognize which fields are date fields without telling so in the script, but the issue is that the format is wrong. It would be nice if the procedure would be more automated than writing code for each individual field.