Change Format Date in Expression Column

[Birgita Juliana]

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]

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]))  

  

2. 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.

  

2. Click the settings button and choose the “Settings” option

  

3. 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.

   

4. 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]

Hi Renuka,

Thank you for help to solving my problem.

Best Regards,

Juliana

[Renuka N]

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. 

[french macdonald]

I had the same issue before. Changing the date format in expression columns can be a bit tricky, depending on whether you’re using GridGroupingControl or DataGrid.

[Suriya]

Hi french macdonald,

Thank you for reaching out.

If you are using GridGroupingControl, please refer to the following KB article to achieve your requirement: How to change the date time Format in WinForms GridGroupingControl? 

Alternatively, if you are using DataGrid control, you can refer to: How to set the custom date time format in WPF GridDataControl?

Revert back for any queries.

Thanks,

Suriya

[barlow jenkins]

I had the same issue before. Changing the date format in expression columns can be a bit tricky, depending on whether you’re using GridGroupingControl or DataGrid.