We are at Atlassian Summit - which will affect our response times. Meet us there (if you happen to be in San Jose)

Skip to end of metadata
Go to start of metadata

The table grid editor documentation has moved to Table Grid Editor for Jira Server Documentation.


Overview Table Grid Editor Table Grid Reader Multi Level Cascade Still working on multiple issue trackers ? Synchronize any data flexibly with exalate


Format the date when a column is a date type

Class

Column

Property

col.xyz.formatDate

Formal specification

col.xyz.formatDate ::= <datecomponent> | <datecomponent> <timecomponent>
<datecomponent> ::= yy-mm-dd | dd.M.y | dd-mm-yy | dd/mm/yy | dd-M-yy | dd/mm/y | mm/dd/y | mm/dd/yy
<timecomponent> ::= hh:mm | h:mm a | h:mm A | h:mm | H:mm | HH:mm

Required

no

Default

yy-mm-dd

Version

1.5

Comment

format

example

yy-mm-dd

2009-10-20

dd.M.y

20.Oct.09

dd-mm-yy

20-10-2009

dd/mm/yy

20/10/2009

dd-M-yy

10-Oct-2009

dd/mm/y

20/10/09

mm/dd/y

10/20/09

dd-M-yy hh:mm

20/10/2009 20:10

mm/dd/yy h:mm a

10/20/2009 8:10 pm

|

Example

col.dob.formatDate = dd/mm/yy

Reference

col.xyz.type = date
col.xyz.type = datetime

 

 

Placeholder meaning

 

PlaceholderDescription
yyYear with century - 2018
mmMonth in number - 01 .. 12
ddDay in number - 01 .. 31
yYear with centrury - 01 .. 99
M

Month name - abbreviated
Locale depends on JIRA setting 

hHours in 12 hour format - 1, 2, 3 .. 12
hhHours in 12 hour format - 2 digits - 01, 02, ... 12
HHours in 24 hour format - 1, 2, 3 .. 23
HHHours in 23 format - 2 digits - 01, 02, .. 23
a

am/pm notation lower case

AAM/PM notation upper case