| Item | EU Slash | EU Dot | US | ISO (UTC) |
|---|---|---|---|---|
| Before threshold | 31/12/2024 23:59:59 | 31.12.2024 23:59:59 | 12/31/2024 23:59:59 | 2024-12-31T23:59:59Z |
| Equal to threshold | 05/01/2025 00:00:00 | 05.01.2025 00:00:00 | 1/5/2025 00:00:00 | 2025-01-05T00:00:00Z |
| After threshold | 06/01/2025 00:00:00 | 06.01.2025 00:00:00 | 1/6/2025 00:00:00 | 2025-01-06T00:00:00Z |
| Missing / empty |
Demonstrates type: 'date' comparisons on an HTML DataTable. Each column uses a different
input format (including common PowerShell/.NET style formats) while using the same threshold date.
var threshold = { year: 2025, month: 1, day: 5, hours: 0, minutes: 0, seconds: 0 };
columnHighlighter: {
rules: [
{
conditionsContainer: [
{
logic: 'AND',
conditions: [
{
columnName: 'EU Slash',
operator: 'lt',
type: 'date',
valueDate: threshold,
dateTimeFormat: 'dd/MM/YYYY HH:mm:ss'
}
]
}
],
targets: [
{ column: 'EU Slash', css: { 'background-color': '#ffdddd', color: '#000' } }
]
}
]
}