Date

A date type attribute, variable or expression can be in the range of 1/1/100 to 12/31/32,767.

info

In Qodly, a date can be stored in two data types:

• a date type, expressed in the yyyy-mm-dd format, for example '2023-12-05'
• an ISO date format string, expressed in the following format: yyyy-mm-ddThh:mm:ss.sssZ (e.g., "2023-12-05T23:00:00.000Z" for december 5, 2023 in the Central European Timezone). sss represents the milliseconds and can be between 0 to 999.

You can select the data type for a Date attribute in your model. This page describes the handling of the date type.

Date literals

A date literal constant is enclosed by exclamation marks (!…!). A date must be structured using the ISO format (!YYYY-MM-DD!). Here are some examples of date constants:

!1976-01-01!
!2004-09-29!
!2023-12-31!

A null date is specified by !00-00-00!.

note

Qodly accepts two-digit years to be entered. A two-digit year is assumed to be in the 20th or 21st century based on whether it is greater or less than 30.

Date operators

Operation	Syntax	Returns	Expression	Value
Date difference	Date – Date	Number	!2023-01-20! - !2023-01-01!	19
Day addition	Date + Number	Date	!2023-01-20! + 9	!2023-01-29!
Day subtraction	Date – Number	Date	!2023-01-20! - 9	!2023-01-11!
Equality	Date == Date	Boolean	!2023-01-01! == !2023-01-01!	true
			!2023-01-20! == !2023-01-01!	false
Inequality	Date != Date	Boolean	!2023-01-20! != !2023-01-01!	true
			!2023-01-20! != !2023-01-20!	false
Greater than	Date > Date	Boolean	!2023-01-20! > !2023-01-01!	true
			!2023-01-20! > !2023-01-20!	false
Less than	Date < Date	Boolean	!2023-01-01! < !2023-01-20!	true
			!2023-01-20! < !2023-01-20!	false
Greater than or equal to	Date >= Date	Boolean	!2023-01-20! >= !2023-01-01!	true
			!2023-01-01!>= !2023-01-20!	false
Less than or equal to	Date <= Date	Boolean	!2023-01-01! <= !2023-01-20!	true
			!2023-01-20! <= !2023-01-01!	false