FEEL

date

FEEL built-in function · FEEL date and time functions

date(from) or date(year, month, day)

Creates a date from an ISO 8601 string, from year/month/day components, or by truncating a date and time value.

The string form is strict ISO 8601, YYYY-MM-DD with zero-padded month and day. Anything else, including impossible dates such as 30 February, gives null rather than an error, so a mistyped date shows up later as a null result. The @"2026-07-24" literal is shorthand for the same thing.

Parameters

ParameterTypeDescription
fromstring or date and timeISO 8601 date string, or a date and time to truncate
year, month, daynumbersdate components (alternative form)

Examples

date("2026-07-24")
2026-07-24 Try it ↑
date(2026, 7, 24)
2026-07-24 Try it ↑
date(date and time("2026-07-24T13:00:00"))
2026-07-24 Try it ↑

Edge cases and null handling

date("2026-7-24")

Month and day must be zero-padded.

date("2026-02-30")

Impossible dates give null.

date("2026-07-24T10:00:00")

A date and time string is not a date string. Wrap it: date(date and time(...)).

date(2026, 13, 1)
date(date and time("2026-07-24T10:00:00"))
2026-07-24 Try it ↑

To get the date of a date and time, convert the value, not the string.

@"2026-07-24" = date("2026-07-24")

The @ literal is the same value.

date("2026-07-24").weekday

Components: .year, .month, .day, .weekday (1 = Monday).

Related functions

time · date and time · duration

Defined by the OMG DMN 1.6 specification, chapter 10.3.4 (built-in functions).