Blazor DataGrid (sFGrid) GridColumn Datetime Custom Formats

[Mike Vinson]

Hello, 

Could you please link the documentation on all avaliavle datatime formats to use in a data-grid column.

EXAMPLE:

<GridColumn Field=@nameof(FMDowntimeFrmEntryS.EndTime) HeaderText="EndTime" Width="75" Format='MM/dd/yyyy HH:mm'></GridColumn>

In the example above the data and time is formatted correctly however it is in Zulu time (10/11/2022 14:40) which does not display times in AM or PM format. What is the correct format for the date output of 10/11/2022 2:40 PM?

Thanks!

[Naveen Palanivel]

Hi Mike,

  Greetings from Syncfusion support.

  Based on your query, you want to display times in AM or PM format to displayed in your grid. Your requirement can be achieved by using  the ` Format="MM/dd/yyyy hh:mm tt"`.

Please refer the below code example.

        <GridColumn Field=@nameof(Order.OrderDate) HeaderText="Order Date"  Format="MM/dd/yyyy hh:mm tt" TextAlign="TextAlign.Right" Width="130" Type="ColumnType.Date"></GridColumn>

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn>

Please get back to us for further details.

Regards,

Naveen

 

[Mike Vinson]

Great, thank you Naveen!

[Naveen Palanivel]

Hi Mike,

Welcome

Please get back to us if you need further assistance.

Regards,

Naveen .