Skip to main content

​
Basic Date Column Configuration

To add a date column to your RISKSHEET, specify the column type and optional format: 
{
  "header": "Due Date",
  "bindings": "dueDate",
  "id": "dueDate",
  "type": "date",
  "format": "d",
  "width": 120,
  "level": 1
}

​
Date and Time Column Types

Nextedy RISKSHEET supports three temporal column types:
TypeDescriptionExample Display
dateDate only (no time)2/6/2025
datetimeDate with time2/6/2025 1:36 PM
timeTime only1:36 PM

​
Date Column Example

{
  "header": "Review Date",
  "bindings": "reviewDate",
  "type": "date",
  "format": "D",
  "level": 1
}

​
DateTime Column Example

{
  "header": "Created",
  "bindings": "created",
  "type": "datetime",
  "format": "f",
  "readOnly": true,
  "level": 1
}

​
Time Column Example

{
  "header": "Meeting Time",
  "bindings": "meetingTime",
  "type": "time",
  "format": "T",
  "level": 1
}

​
Date Format Options

The format property controls how dates display in the grid. Formats are applied based on the culture setting (configured via global.culture).

​
Common Date Formats

Format CodeDescriptionExample (en-US)
dShort Date Pattern2/6/2025
DLong Date PatternSaturday, February 06, 2025
fFull Date/Time (short time)Saturday, February 06, 2025 1:36 PM
FFull Date/Time (long time)Saturday, February 06, 2025 1:36:27 PM
tShort Time Pattern1:36 PM
TLong Time Pattern1:36:27 PM
'Q'Q yyyyQuarter/YearQ1 2025
MMMM dd, yyyyCustom formatFebruary 06, 2025

​
Custom Date Formats

You can create custom date formats using standard format tokens: 
{
  "header": "Deadline",
  "bindings": "deadline",
  "type": "date",
  "format": "yyyy-MM-dd",
  "level": 1
}
This displays dates as: 2025-02-06

​
Date Input Methods

Users can input dates in RISKSHEET using two methods:
MethodInteractionFormat
Calendar PickerClick cell, select date from popupDisplay format from config
Direct EntryClick cell, type date, press EnterAlways YYYY-MM-DD (ISO)

​
Direct Entry Format

When typing dates directly into cells, always use ISO format: YYYY-MM-DD Example: 2025-02-06 for February 6, 2025
Regardless of the display format configured for the column, direct cell entry always requires ISO format (YYYY-MM-DD). The system automatically converts this to the configured display format after entry.

​
Localization and Culture Settings

Date formats are influenced by the culture setting in your risksheet.json: 
"global": {
  "culture": "en-US"
}
Different cultures display dates differently:
  • en-US: 2/6/2025 (MM/DD/YYYY)
  • en-GB: 6/2/2025 (DD/MM/YYYY)
  • de-DE: 06.02.2025 (DD.MM.YYYY)
See Culture and Localization Codes for all supported culture codes.

​
Upstream Date Columns

To display date fields from linked upstream items: 
{
  "header": "Requirement Due Date",
  "bindings": "requirement.dueDate",
  "type": "date",
  "format": "d",
  "readOnly": true,
  "level": 2
}
By default, upstream sub-columns are read-only. To enable editing: 
{
  "header": "Requirement Due Date",
  "bindings": "requirement.dueDate",
  "type": "date",
  "format": "d",
  "readOnly": false,
  "level": 2
}
The property must be spelled "readOnly" (camelCase), not "readonly" (lowercase). Using lowercase will cause the property to be ignored, and the column will remain read-only.

​
Common Pitfalls

In RISKSHEET versions 24.5.0 through 24.5.x, a regression caused date columns with custom format properties to fail on save. If you encounter save errors with date columns, try removing the format property temporarily or upgrade to the latest version where this issue is resolved.
Date values are parsed in local browser time. If your users are in different timezones, be aware that date-only fields (type: date) may display differently depending on the user’s timezone setting.
Polarion system date fields like created and updated are always read-only and cannot be edited through RISKSHEET, even if "readOnly": false is specified.

​
Verification

After configuring date columns:
  1. Reload your RISKSHEET to apply the configuration
  2. Click a date cell — you should see a calendar picker popup
  3. Select a date from the calendar or type a date in YYYY-MM-DD format
  4. Press Enter or click outside the cell — the date should display in your configured format
  5. Save the RISKSHEET — the date should persist correctly
You should now see date fields displaying in your specified format with proper calendar picker functionality.

​
See Also

KB ArticlesSupport TicketsSource Code
  • CellPreviewFormatter.ts
  • GetSetUtil.java
  • PolarionAppConfigManager.java
  • ResetColumnsCommand.ts
  • ConfigureColumnsCommand.ts