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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formatting dates inside report server web designer

Thread ID:

Created:

Updated:

Platform:

Replies:

146976 Aug 27,2019 12:14 PM UTC Aug 27,2019 02:45 PM UTC Report Platform 3
loading
Tags: Report Designer
CR
Asked On August 27, 2019 12:14 PM UTC

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 [Syncfusion]
Replied On August 27, 2019 02:17 PM UTC

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
Replied On August 27, 2019 02:23 PM UTC

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 [Syncfusion]
Replied On August 27, 2019 02:45 PM UTC

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

Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon