Date and Time Columns - Nextedy Documentation

Column Type Values

Type Value	Polarion Storage	Internal Format	Display Example	Description
`date`	DateOnly	`yyyy-MM-dd`	`2025-03-15`	Date without time component. Calendar picker for editing
`datetime`	Date	ISO DateTime	`2025-03-15 14:30`	Date with time component. Calendar + time picker
`time`	TimeOnly	`hh:mm:ss`	`14:30:00`	Time without date component. Time-only entry

Column Type Storage Format Display Example
date	--->	yyyy-MM-dd	--->	2025-03-15
datetime	--->	ISO DateTime	--->	2025-03-15 14:30
time	--->	hh:mm:ss	--->	14:30:00

Column Properties

Name	Type	Default	Description
`id`	`string`	Auto-generated from header or binding	Unique column identifier
`type`	`string`	Auto-detected from binding	Set to `date`, `datetime`, or `time`. If not specified, Risksheet infers the type from the Polarion field definition
`header`	`string`	Required	Display text shown in the column header
`binding`	`string`	Same as `id`	Polarion field binding name. Must match the work item field ID in Polarion
`width`	`number`	See application	Column width in pixels
`minWidth`	`number`	See application	Minimum width in pixels that the column can be resized to
`format`	`string`	None	Custom display format string (e.g., `"dd/MM/yyyy"`, `"MM-dd-yyyy"`). Controls how the date renders in the cell. See Format Strings
`readOnly`	`boolean`	`false`	Controls whether the column cells can be edited by users. Automatically set to `true` for system date fields (`created`, `updated`). Note: case-sensitive — must be `readOnly` with uppercase O
`level`	`number`	`1`	Hierarchical level at which this column appears (1 = top level, 2 = second level)
`headerGroup`	`string`	None	Name of the header group this column belongs to for multi-level column headers
`headerGroupCss`	`string`	None	CSS class name(s) to apply to the header group row
`collapseTo`	`string`	None	Column ID to collapse this column into when the header group is collapsed
`filterable`	`boolean`	`true`	Controls whether users can filter the risksheet by values in this column
`cellCss`	`string`	None	CSS class name(s) to apply to all cells in this column
`multiLine`	`boolean`	`true`	Not typically relevant for date columns, but inherited from the base column configuration

The readOnly property is case-sensitive: "readOnly": false works correctly, but "readonly": false does not. This is a very common configuration mistake, especially when making upstream linked item date columns editable. Always use the camelCase form readOnly.

Type Conversion

Risksheet automatically converts between different date representations when reading from and writing to Polarion. The conversion system handles multiple source types transparently:

Source Type	Target Format	Description
Polarion Date objects	ISO format strings	Standard Polarion date fields are converted to `yyyy-MM-dd` for dates
Java Date/Calendar objects	ISO format strings	Legacy Polarion date values are normalized
ISO string format (`yyyy-MM-dd`)	Parsed directly	Date strings in ISO format are accepted without conversion
ISO string format (`hh:mm:ss`)	Parsed directly	Time strings in ISO format are accepted without conversion
String fields	Date objects	A string field can be configured as a `date` column; Risksheet attempts to parse the string value as a date
Integer/Float fields	Not applicable	Numeric fields cannot be displayed as date columns

You can display any Polarion field as a date column by setting "type": "date" in the column configuration, regardless of the underlying Polarion field type. For example, a string field can be shown as a date column if its values contain parseable date strings.

Display Formatting

Default Behavior

Date columns with type: "date" parse YYYY-MM-DD format strings to local time Date objects before applying any configured format. The parsing uses local time rather than UTC to avoid off-by-one date shifts from timezone conversion.

Format Strings

The format property accepts format strings compatible with the localization library. Common patterns:

Format String	Output Example	Description
`"yyyy-MM-dd"`	`2025-03-15`	ISO date (default)
`"dd/MM/yyyy"`	`15/03/2025`	European day-first format
`"MM/dd/yyyy"`	`03/15/2025`	US month-first format
`"dd.MM.yyyy"`	`15.03.2025`	German/Central European format
`"d MMM yyyy"`	`15 Mar 2025`	Short month name

Culture-Dependent Formatting

The global.culture property in risksheet.json affects how dates (and numbers) are formatted and parsed. For example, setting "global": { "culture": "de" } changes the default date display to German locale conventions.

{
  "global": {
    "culture": "de"
  }
}

See Culture and Localization Codes for the full list of supported culture codes.

In version 24.5.0, adding a format property to date-only columns caused save errors due to a timezone fix regression. The format property triggered incorrect timezone handling that prevented successful saves.Workaround: Remove the format property from date-only columns and enter dates in YYYY-MM-DD format directly in the cell instead of using the calendar popup. This issue was resolved in subsequent versions.

System Date Fields

Certain Polarion system fields are date-typed and always read-only:

Field Binding	Type	Read-Only	Description
`created`	`datetime`	Always	Work item creation timestamp
`updated`	`datetime`	Always	Last modification timestamp

These fields have readOnly automatically set to true by Risksheet and cannot be made editable.

Upstream Date Columns

To display and edit a date attribute from an upstream linked work item (e.g., a requirement’s due date shown on the risk item row):

Set the binding to the linked item’s date field using dot notation (e.g., req.dueDate)
Set "readOnly": false (case-sensitive, uppercase O) to enable editing
Optionally configure a format string for display

{
  "columns": [
    {
      "id": "reqDueDate",
      "header": "Req. Due Date",
      "binding": "req.dueDate",
      "type": "date",
      "readOnly": false,
      "width": 120,
      "level": 1
    }
  ]
}

Upstream columns need "readOnly": false (case-sensitive with uppercase O) to be editable. Without this property, upstream columns default to read-only since they reference data from another work item.

Date Entry Behavior

When editing a date cell, Risksheet provides a calendar date picker. Users can also type dates directly into the cell. The accepted input format depends on the column configuration:

Scenario	Accepted Input
No `format` property set	`YYYY-MM-DD` (ISO format)
`format` property set	Date string matching the configured format pattern
Calendar picker	Click to select date from calendar dropdown

When the format property is removed (as a workaround for the v24.5.0 bug), enter dates in YYYY-MM-DD format directly in the cell. The calendar popup may not be available in all configurations.

Comparison Mode

Date columns participate in baseline comparison mode. When comparing two document revisions:

Changed date values are highlighted with comparison styling
Tooltips show the old value and new value
Added rows display date values with “new row” indicators
Removed rows display date values with “removed row” indicators

The comparison applies to both master item date columns and downstream task date columns.

Read-Only Field Protection

The following system fields are always read-only and cannot be edited through Risksheet, even if readOnly: false is set:

id — Work item ID
status — Work item status
type — Work item type
project — Project identifier
outlineNumber — Document outline number
created — Creation timestamp
updated — Last modification timestamp
author — Work item author
resolution — Work item resolution

Attempts to save changes to these fields are silently ignored.

Complete Example

An FMEA configuration with target date tracking, completion dates on downstream tasks, and system timestamps:

{
  "global": {
    "culture": "en"
  },
  "columns": [
    {
      "id": "targetDate",
      "header": "Target Date",
      "type": "date",
      "binding": "targetDate",
      "width": 120,
      "level": 2,
      "headerGroup": "Schedule",
      "readOnly": false,
      "filterable": true
    },
    {
      "id": "completionDate",
      "header": "Completed",
      "type": "date",
      "binding": "task.completionDate",
      "width": 120,
      "headerGroup": "Schedule",
      "readOnly": false
    },
    {
      "id": "reviewDate",
      "header": "Review Date",
      "type": "date",
      "binding": "reviewDate",
      "width": 120,
      "level": 2,
      "headerGroup": "Schedule",
      "readOnly": false
    },
    {
      "id": "lastModified",
      "header": "Last Updated",
      "type": "datetime",
      "binding": "updated",
      "width": 150,
      "readOnly": true
    },
    {
      "id": "createdOn",
      "header": "Created",
      "type": "datetime",
      "binding": "created",
      "width": 150,
      "readOnly": true
    },
    {
      "id": "reqDueDate",
      "header": "Req. Due Date",
      "binding": "req.dueDate",
      "type": "date",
      "readOnly": false,
      "width": 120,
      "level": 1,
      "headerGroup": "Requirement"
    }
  ]
}

This configuration provides:

Editable targetDate and completionDate columns for risk item scheduling
Editable reviewDate for tracking review milestones
Read-only lastModified and createdOn columns displaying system timestamps
Editable upstream reqDueDate showing the linked requirement’s due date

Column Type Reference — overview of all column types
Data Types — complete data type reference
Culture and Localization Codes — locale settings affecting date formats
Configure Date Fields — step-by-step how-to guide
Configuration Properties Index — global configuration reference
Supported Field Types — Polarion field type mappings

Sources

Support Tickets

#5961
#5973

Source Code

GetSetUtil.java
PolarionAppConfigManager.java
CellPreviewFormatter.ts
risksheet.json
SheetConstants.ts

​Column Type Values

​Column Properties

​Type Conversion

​Display Formatting

​Default Behavior

​Format Strings

​Culture-Dependent Formatting

​System Date Fields

​Upstream Date Columns

​Date Entry Behavior

​Comparison Mode

​Read-Only Field Protection

​Complete Example

​Related Pages

Column Type Values

Column Properties

Type Conversion

Display Formatting

Default Behavior

Format Strings

Culture-Dependent Formatting

System Date Fields

Upstream Date Columns

Date Entry Behavior

Comparison Mode

Read-Only Field Protection

Complete Example

Related Pages