Skip to main content
Mar 12, 2021 4:30 AM UTC
Question

Change the datetime format of grid values using localization token

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.

 

 

2 replies

Mar 12, 2021 4:50 AM UTC

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

Mar 19, 2021 9:09 AM UTC

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 :

Screenshot 2021-03-19 at 10.07.00.png