Hello ,

I am just checking if you got this worked out or you still require any assistance or clarification on the matter.

If this is what you were looking for please verify the answer so it helps other users as well.

Hello,

I have investigated this further and have a solution to what I think is your requirement. You have string date which you want use as DateTime in the XamDataGrid (for sorting, and have it formatted as “DD MMM yyyy” ) and want to export to excel as string. What you can do is use this xaml snippet:

<igDP:Field Name="StringBirthDay">

    <igDP:Field.Settings>

        <igDP:FieldSettings  >

            <igDP:FieldSettings.EditorStyle>

                <Style TargetType="{x:Type igEditors:XamDateTimeEditor}">

                    <Setter Property="Format" Value="ddd MMM yyyy"/>

                </Style>

            </igDP:FieldSettings.EditorStyle>

        </igDP:FieldSettings>

    </igDP:Field.Settings>

</igDP:Field>