col.xyz.formatDate

Owned by svitlana (Deactivated)
Last updated: Oct 18, 2023 by Dam
1 min read

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

Placeholder

Description

Placeholder

Description

yy

Year with century - 2018

mm

Month in number - 01 .. 12

dd

Day in number - 01 .. 31

y

Year with centrury - 01 .. 99

M

Month name - abbreviated
Locale depends on JIRA setting 

h

Hours in 12 hour format - 1, 2, 3 .. 12

hh

Hours in 12 hour format - 2 digits - 01, 02, ... 12

H

Hours in 24 hour format - 1, 2, 3 .. 23

HH

Hours in 23 format - 2 digits - 01, 02, .. 23

a

am/pm notation lower case

A

AM/PM notation upper case