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

Change Format Date in Expression Column

Thread ID:

Created:

Updated:

Platform:

Replies:

145301 Jun 17,2019 03:08 AM UTC Jun 17,2019 07:17 AM UTC Dashboard Platform 3
loading
Tags: Dashboard Designer
Birgita Juliana
Asked On June 17, 2019 03:12 AM UTC

Hi support team,

I want to change format of date from 'yyyy-MM-dd' to 'dd-MM-yyyy' in expression column.
Could you show me the way how to change format of date in expression column?
Thank you for your attention,

Best Regards,


Juliana

Renuka N [Syncfusion]
Replied On June 17, 2019 06:09 AM UTC

Hi Juliana,  

Thanks for contacting Syncfusion support.
 
 
We can achieve your requirement in two ways by using either "Expression" or “Custom date format” option.  
  1. By using Expression:
Create an Expression like as below to convert your date column format,  
CONCAT(DATEPART("day", [date column]), '-', DATEPART("month", [date column]), '-', DATEPART("year", [date column]))  
  
  1. By using Custom date format option:
  1. Bind your date column in a widget and select Date format by clicking the “Settings” button. For Example Grid widget.
  
  1. Click the settings button and choose the “Settings” option
  
  1. In the Format combo box, select the “Custom Format option” and enter your desired format in Custom Format text box of Date Settings window. Finally, click OK button.
   
  1. The resultant grid will be shown as like below,
   
Note:  
Custom format option has been restricted for some controls like the chart. Please refer below documentation link to know more about custom formatting option, https://help.syncfusion.com/dashboard-platform/dashboard-designer/compose-dashboard/custom-date-formatting   
 
Please let us know, if you have any other queries. 
 
Regards, 
Renuka N. 


Birgita Juliana
Replied On June 17, 2019 06:25 AM UTC

Hi Renuka,
Thank you for help to solving my problem.

Best Regards,


Juliana

Renuka N [Syncfusion]
Replied On June 17, 2019 07:17 AM UTC

Hi Juliana,  

Thanks for your update.
 
 
We are glad that the provided solution works at your end. Please let us know, if you need any further assistance. 
 
Regards, 
Renuka N. 


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