Data formatting in DataGrid dynamic data

[Ramon1]

Hello.
I use DataGrid dynamic data from witch datasource is a JSON from an API call.
I cannot format Decimal and DateTime data types.
I use like this:

Can you give me some advice?
Thank you in advance

[enchev]

You can use String.Format() similar to various examples in our demos.

[korchev]

When you use Template it will override the FormatString setting. Either remove the template or change it to use String.Format as @enchev suggested:

<Template>
   @string.Format("{0:d}", context[column.Key])
</Template>

[promwi]

Can you elaborate on "remove the template"? What would then replace it? Does this affect filter & sorting?
Thanks

[korchev]

@promwi

Can you elaborate on "remove the template"?

It means to remove the <Template></Template> tag altogether.

@promwi

What would then replace it?

Not sure what you want to replace it with. My answer to this thread provides a solution already.

@promwi

Does this affect filter & sorting?

No. The template only affects the display of the data. Filtering and sorting works with the data.