Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT remote actions

Cloud migration hub

Additional product info

Versions Compared

Old Version 5

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Julian Riedinger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


UI Text Box
sizemedium
typeinfo

This function returns the year part of a timestamp based on a given time zone. 


Code Block
languagebash
titleSyntax
linenumberstrue
year(timestamp, timeZone) #Output: Number


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
 %{year({issue.created}, RUN_AS_LOCAL)}



This example returns the year part of the issue creation date
Info
typeinfo

If the issue was created on March 25th, 2020 23:15:30 the output would be 2020.




Code Block
languagebash
linenumberstrue
%{year(stringToDate("2020-01-01 00:30","Europe/Berlin"),"UTC")}


This example returns the year part of the given date, the timezone is UTC.

Info
typeinfo

Due to the time zone UTC, the output will be 2019.




UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
timeZone

Status
subtletrue
titletext

The time zone used for the calculation. 


UI Text Box
typetip

Work days might depend on the time zone - it might be Dec 31st on the west coast of the US while at the same time it's already Monday Jan 1st in Australia. 



UI Expand
titleOutput

This function returns a

Status
subtletrue
titlenumber



Use cases and examples

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Field type, Automated action, Parser functions
cqllabel = "parser_func_year" and space = currentSpace()


Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourYellow
titleReady for review

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



Page properties
hiddentrue


Short description

Returns the year part of a timestamp.

Output

Status
subtletrue
titlenumber

Label