Check out our new app to find attachments by file name, format, or uploader in Jira Cloud.
Page tree
Skip to end of metadata
Go to start of metadata

On this page you will learn how to:


Set the date format

You may need to set the correct date format:

The macros may work incorrectly if the incorrect date format is specified.




Supported date formats

You can select the date format from the list os predefined date formats or specify it as a string value. See the next table for details:

String Value

Example

d - day of month (no leading zero)

1
dd - day of month (two digits)01
w - week of year (no leading zero)1
ww - week of year (two digits)01
m - month of year (no leading zero)1
mm - month of year (two digits)01

M - month name short

Jan
MM - month name longJanuary
y - year (two digits)19
yy - year (four digits)2019
Qi - quarter (Q+digit)Q1
hh - hour (two digits)01
mm - minute (two digits)01
ss - second (two digits)01

o - day of the year (no leading zeros)

1
oo - day of the year (three digits)001

If you use the string value for setting the date format, you can combine and customize them to your needs, as follows:

  • mm/dd/yy - 12/31/2014 or 05/07/2019
  • m/d/yy - 5/7/2019
  • dd M, yy - 15 Jun, 2019
  • dd MM, yy - 27 August, 2019
  • mm-dd-yy - 12-31-2019 and others.
  • yy-mm-dd hh:mm:ss - 2019-12-20 10:27:30
  • yy Qi - 2019 Q1



How to set the date format

Table Filter

In the page view mode

  1. On the filtration pane, locate the cogwheel icon and click it.
  2. Select Modify settings.
  3. Select the correct date and time format from the list or manually specify the needed format.
  4. Click Update.
  5. Save changes if needed.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode. The feature is not available in Cloud version

In the macro browser

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Date format box.
  5. Select the correct date format from the list or manually specify the needed format.
  6. Save the macro and the page.


Pivot Table

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Date format box.
  5. Select the correct date format from the list or manually specify the needed format.

  6. Save the macro and the page.


Chart from Table

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Locate the Date format option.
  5. Specify the correct date format for date values in the source table.
  6. Save the macro and the page.

If the app detects the incorrect date format in the page view mode it presents you with the note panel where you can enter the correct date format. It is saved automatically if it is treated as the correct date format.


Table Transformer

  1. Select the macro and click Edit.
  2. Switch to the Settings tab.
  3. Select the correct date format from the list or manually specify the needed format.
  4. Save the macro and the page.


Set the worklog settings

Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration (Table Filter) / Options (Pivot Table) / Adjustments (Chart from Table) / Settings (Table Transformer) tab.
  4. Click the Set worklog settings button.
  5. In the opened form, define the worklog parameters, as follows:
    1. Days in week - enter the number of business days in a week.
    2. Hours in day - enter the number of working hours in one business day.
    3. Time format - select the used time format in worklog values.
    4. Week shortening - enter the shortening for the week time unit if you use any language different from English.
    5. Day shortening - enter the shortening for the day time unit if you use any language different from English.
    6. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
    7. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
  6. Click Save.
  7. Save the macro and the page.

Worklog time units in different languages are denoted with different shortenings. Please adjust them according to your JIRA localization settings.

When working with worklogs in the Table Filter macro:

  • Use the correct format for entering worklogs:
    • Xw - for weeks (for example, '2w').
    • Xd - for days (for example, '3d').
    • Xh - for hours (for example, '5h').
    • Xm - for minutes (for example, '45m').
  • Use the correct time format ('hh:mm:ss') for setting time intervals.


Set the dynamic time intervals

You can set the dynamic time intervals in the date picker in the Table Filter macro in the following format:

  • today - for filtering until today or starting from today.
  • +/-Xy - for setting yearly intervals in future or in past.
  • +/-Xm - for setting monthly intervals in future or in past.
  • +/-Xw - for setting weekly intervals in future or in past.
  • +/-Xd - for setting the daily intervals in future or in past.

If you need to set some complex interval, enter it as a single string, like: -2m 3w 5d. The current browser date is used as a starting date for data filtration according to the specified time intervals.

  1. Open the page with the table for filtration.
  2. On the filtration pane, locate the date range filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate date interval in the correct date format.




  • No labels