Formatting dates inside report server web designer

[CR]

Dear Forum, 

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?

Thanks a mil in advance for any hints.

Kind regards 

CR

[Vinoth Srinivasan]

Hi Chris, 

 

Thanks for your interest in Syncfusion products. 

 

You can achieve your requirement using the below expression. 

 

=FORMAT(Fields!FieldName.Value,"dd.MM.yyyy") 

 

Regards, 

Vinoth S. 

[CR]

Dear Vinoth

Thanks a mil for your prompt reply and for your help. Your suggestion did indeed resolve the issue. 

Thanks again for helping me out. 

Kind regards

CR

[Vinoth Srinivasan]

Hi Chris, 

 

Thanks for your update. Please let us know if you need further assistance. 

Regards, 

Vinoth S. 

[Zsofia Hornyeki]

Hello,

I tried to apply the format expression you shared, but it looks like my we designer ignores it, however saving the expression was successful. Displayed values in designer:

Used format:

Could you help with it? 

Thank you

[Arumugasami Murugesan]

Hi Zsofia Hornyeki,

Thanks for contacting Bold Report support.

We have created a ticket for your query. Please check the ticket from the below site and follow further.

https://support.boldreports.com/support/tickets

Regards,

Arumugasami M