View Issue Details

IDProjectCategoryView StatusLast Update
0000037Inlyra StudioFormula / Expressionspublic2026-09-26 16:57
Reporterinlyradev Assigned Toinlyradev  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Target Versionv1.0.0 
Summary0000037: Expand and Standardize Date/Time Formula Functions
DescriptionExpand Inlyra's Date/Time formula functionality and standardize function naming before the v1.0 release.

As Inlyra is still pre-release, existing date functions should be renamed to use the preferred function naming convention rather than retaining backward-compatible aliases.

Rename existing functions:

DATE_PART() → DATEPART()
DATE_DIFF() → DATEDIFF()
DATE_TRUNC() → DATETRUNC()

Inlyra function names should generally avoid underscores when a clear and readable name can be used.

New Date Manipulation Functions

DATEADD(interval, amount, date)
Adds or subtracts an interval from a date or datetime. Negative amounts subtract.

Supported intervals should include:

year
quarter
month
week
day
hour
minute
second

Example:

DATEADD('month', -1, [OrderDate])
DATEADD('day', 30, [OrderDate])
DATEADD('hour', 2, [Timestamp])

FODATE(interval, date [, weekStart])
Returns the first date of the calendar period containing the supplied date.

Examples for 8/23/2026:

FODATE('year', [mydate]) → 1/1/2026
FODATE('quarter', [mydate]) → 7/1/2026
FODATE('month', [mydate]) → 8/1/2026

EODATE(interval, date [, weekStart])
Returns the last date of the calendar period containing the supplied date.

Examples for 8/23/2026:

EODATE('year', [mydate]) → 12/31/2026
EODATE('quarter', [mydate]) → 9/30/2026
EODATE('month', [mydate]) → 8/31/2026

Month-end calculations must correctly handle different month lengths and leap years.

Examples:

EODATE('month', DATE(2024,2,15)) → 2/29/2024
EODATE('month', DATE(2025,2,15)) → 2/28/2025
Week Handling

For FODATE('week', ...) and EODATE('week', ...), support an optional third parameter specifying the first day of the week:

1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday

Default should be Monday when omitted.

Example:

FODATE('week', [mydate], 1)
EODATE('week', [mydate], 1)

The weekStart argument should only be valid when the interval is week.

Convenience Date/Time Functions

Add commonly used component functions:

YEAR(date)
QUARTER(date)
MONTH(date)
WEEK(date)
WEEKDAY(date)
DAY(date)

HOUR(datetime)
MINUTE(datetime)
SECOND(datetime)

TIME(hour, minute, second)

These provide simpler alternatives to DATEPART() for common operations.

Resulting Date/Time Formula Family

The intended v1.0 Date/Time API would be:

DATE()
TIME()

TODAY()
NOW()

DATEADD()
DATEDIFF()
DATEPART()
DATETRUNC()

FODATE()
EODATE()

YEAR()
QUARTER()
MONTH()
WEEK()
WEEKDAY()
DAY()

HOUR()
MINUTE()
SECOND()
Additional InformationAdditional Requirements
Update Formula Editor autocomplete/function help.
Update Formula validation/error messages.
Update Formula Reference documentation.
Update automated formula tests.
Update any bundled examples/workflows using the old underscore function names.
No backward-compatible aliases are required for DATE_PART, DATE_DIFF, or DATE_TRUNC because Inlyra has not yet reached its public v1.0 release.
TagsNo tags attached.
Report TypeEnhancement
EditionBoth
Operating SystemWindows 11

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2026-09-20 02:08 inlyradev New Issue
2026-09-26 16:39 inlyradev Assigned To => inlyradev
2026-09-26 16:39 inlyradev Status new => assigned
2026-09-26 16:48 inlyradev Assigned To inlyradev =>
2026-09-26 16:57 inlyradev Assigned To => inlyradev
2026-09-26 16:57 inlyradev Status assigned => resolved
2026-09-26 16:57 inlyradev Resolution open => fixed