Show time portion of DateTime field in DataGrids

LabKey Support Forum (Inactive)
Show time portion of DateTime field in DataGrids Jon (LabKey DevOps)  2015-08-06 23:12
Status: Closed
 
Hi Anthony,

Yes, you can show the time portion of a DateTime field in a data grid by editing the format of the datagrid. We work off of the same Java formatting when it comes to date and time.

For example, if you look at my screenshot, you'll see that I've edited a list where I have a DateTime field and the Format box filled in using the following value:

EEE, d MMM yyyy HH:mm:ss

Which then translates the information I entered into my list as:

Thu, 1 Jan 2015 10:11:11

So if you go into any of your datagrids and edit the fields, you can modify the format accordingly for the datetime ones.

For information on the various format strings and examples available, please visit the link below:

https://www.labkey.org/wiki/home/Documentation/page.view?name=dateFormats

Regards,

jon