I am currently working on a report using the online report designer. The current report requires some dates (taken from a data source) to be displayed in the European/German format , i.e 31.10.2019 instead of 10/31/2019. However, the overall system is set up as us-en. The overall server language settings should not be changed.
As for the current issue, I already tried using a formula along the lines of FormatDateTime([field1], DateFormat("dd.MM.yyyy") ), however this approach was not successful.
I was wondering if there was a way to change the format using some kind of date string format on the respective field such as "dd.MM.yyyy". Please note that access is limited to just the web report designer and the data source.
Could somebody provide me with a formula or some other solution?