Change the datetime format of grid values using localization token

[ranjank]

Hi Team,

In our application, default date time format is being used "dateTimeFormat_Default YYYY-MM-dd HH:mm:ss" in grid column values but we want to show at some place using this format "HH:mm:ss YYYY-MM-dd".

Please guide me how to get this format values display on grid.

Thanks in advance.

[SachinSharma]

Hi @ranjank 

Date time format displayed in grid can be changed using the Localization Tokens defined in the Default localization table. Navigate to System> Localization Table> Default> dateTimeFormat_Default and update the format there.

Regards,

Sachin

[cbrandy-2]

In the "configure grid columns" menu of the advanced grid, you can format each column individually.

You can choose DATETIME  and either choose a localisation token or use your own format :