We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Formatting dates inside report server web designer

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

3 Replies

VS Vinoth Srinivasan Syncfusion Team August 27, 2019 06:17 AM

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 CR August 27, 2019 06:23 AM

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


VS Vinoth Srinivasan Syncfusion Team August 27, 2019 06:45 AM

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

Regards, 
Vinoth S. 


Loader.
Live Chat Icon For mobile
Up arrow icon