Column Types Type Display Format Storage Format Use Case dateYYYY-MM-DD ISO 8601 date only Start dates, target dates, milestones datetimeYYYY-MM-DD HH:MM:SS ISO 8601 with time Timestamps, deadlines with precision timeHH:MM:SS Time only Duration start/end, work hours
Configuration Properties Basic Date Column Name Type Default Description headerstring Required Column header text bindingstring Required Polarion field reference (e.g., targetDate, createdDate) typestring auto-detect Set to date for date-only columns widthnumber auto Column width in pixels readOnlyboolean false Prevent editing of date values filterableboolean true Allow users to filter by date range formatstring locale default Custom date format string (see Globalize documentation)
Example: Basic Date Configuration { "header" : "Target Date" , "binding" : "targetDate" , "type" : "date" , "width" : 120 , "filterable" : true }
DateTime Columns (Date + Time) Datetime columns capture both date and time information for precise temporal tracking.
Name Type Default Description headerstring Required Column header text bindingstring Required Polarion field reference typestring auto-detect Set to datetime for date and time formatstring locale default Format string for display (e.g., yyyy-MM-dd HH:mm:ss) readOnlyboolean false Prevent editing
Example: DateTime Configuration { "header" : "Deadline" , "binding" : "dueDateTime" , "type" : "datetime" , "width" : 160 , "format" : "yyyy-MM-dd HH:mm" }
Time-Only Columns Time columns display and edit time values without date information, useful for duration tracking and shift management.
Name Type Default Description headerstring Required Column header text bindingstring Required Polarion field reference typestring auto-detect Set to time for time-only values formatstring HH:mm:ss Time format string readOnlyboolean false Prevent editing
Example: Time Configuration { "header" : "Work Start Time" , "binding" : "workStartTime" , "type" : "time" , "width" : 100 }
The system accepts multiple date input formats and automatically converts to ISO 8601:
Input Format Interpretation 2026-02-12Parsed as YYYY-MM-DD 02/12/2026Parsed based on locale 2/12Parsed as relative to current year todaySets to current date tomorrowSets to next day
Keyboard Shortcuts Shortcut Action Ctrl+;Insert today’s date ↑ / ↓Increment/decrement date by 1 day Ctrl+↑ / Ctrl+↓Increment/decrement by 1 month
Date format strings use Globalize syntax for localization:
Format Example Notes yyyy-MM-dd2026-02-12 ISO 8601 standard dd/MM/yyyy12/02/2026 European format MM/dd/yyyy02/12/2026 US format yyyy-MM-dd HH:mm:ss2026-02-12 14:30:00 Full datetime d MMM yyyy12 Feb 2026 Abbreviated month
{ "header" : "Review Date" , "binding" : "reviewDate" , "type" : "date" , "format" : "dddd, d MMMM yyyy" }
This renders as: “Wednesday, 12 February 2026”
Localization and Culture Date formatting respects the global culture setting in your risksheet.json configuration:
{ "global" : { "culture" : "de-DE" } }
Common culture codes:
Code Language Date Format en-USEnglish (US) MM/dd/yyyy en-GBEnglish (UK) dd/MM/yyyy de-DEGerman dd.MM.yyyy fr-FRFrench dd/MM/yyyy ja-JPJapanese yyyy/MM/dd
Linking Date Columns to Polarion Fields Date columns support binding to various Polarion field types:
Polarion Field Type Column Type Notes DateOnlydateNative date field DatedatetimeIncludes time component CustomField (Date)date or datetimeCustom field with date type StringdateAuto-converted from ISO format
Example: Binding to Custom Date Fields { "header" : "Schedule Start" , "binding" : "customFields/scheduleStartDate" , "type" : "date" , "width" : 120 }
Comparison and Filtering Date columns support advanced filtering and comparison operations:
Filter Operators Equals: 2026-02-12 Before: < 2026-02-12 After: > 2026-02-12 Between: 2026-01-01 to 2026-12-31 Is empty Is not empty
formulas . daysUntilDue = function ( info ) { var today = new Date (); var dueDate = new Date ( info . item [ 'dueDate' ]); var diff = Math . ceil (( dueDate - today ) / ( 1000 * 60 * 60 * 24 )); return diff >= 0 ? diff : 'OVERDUE' ; }
Visual Decision Matrix Use Case Column Type Date-only values (milestones, targets) datePrecise timestamp (deadlines, events) datetimeTime-only tracking (work hours, shifts) time
Use datetime for most risk management workflows where precision is important. Use date for planning dates where time is irrelevant. Time-only columns are rarely needed in FMEA/HARA analyses.
All date values are stored in ISO 8601 format internally (YYYY-MM-DD for dates, HH:MM:SS for times) regardless of display format. The display format only affects how users see the data in the grid.
Version Compatibility Feature Added Status Date columns v19.0 Stable DateTime columns v19.0 Stable Time columns v20.0 Stable Custom format strings v21.0 Stable Culture-aware formatting v22.0 Stable
Editing Date Values When editing date cells, users see an inline date picker:
Disabling Date Picker For read-only analysis columns, set readOnly: true:
{ "header" : "Analysis Date" , "binding" : "analysisDate" , "type" : "date" , "readOnly" : true }
Common Patterns Pattern 1: Risk Assessment Timeline [ { "header" : "Identified" , "binding" : "identifiedDate" , "type" : "date" }, { "header" : "Target Mitigation" , "binding" : "targetDate" , "type" : "date" }, { "header" : "Resolution Deadline" , "binding" : "deadline" , "type" : "datetime" }, { "header" : "Closed" , "binding" : "closedDate" , "type" : "date" , "readOnly" : true } ]
Pattern 2: Review and Approval Tracking [ { "header" : "Review Due" , "binding" : "reviewDueDate" , "type" : "date" }, { "header" : "Reviewed At" , "binding" : "reviewedDateTime" , "type" : "datetime" , "readOnly" : true }, { "header" : "Approved At" , "binding" : "approvedDateTime" , "type" : "datetime" , "readOnly" : true } ]
System Fields Certain Polarion system fields are always read-only date columns:
Field Type Read-Only Description createddatetime Yes Work item creation timestamp updateddatetime Yes Last modification timestamp dueDatedate No Built-in due date field
Related Pages
Source Code
GetSetUtil.javaPolarionAppConfigManager.javaCellPreviewFormatter.tsrisksheet.jsonSheetConstants.ts 
