View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000037 | Inlyra Studio | Formula / Expressions | public | 2026-09-20 02:08 | 2026-09-26 16:57 |
| Reporter | inlyradev | Assigned To | inlyradev | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Target Version | v1.0.0 | ||||
| Summary | 0000037: Expand and Standardize Date/Time Formula Functions | ||||
| Description | Expand 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 Information | Additional 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. | ||||
| Tags | No tags attached. | ||||
| Report Type | Enhancement | ||||
| Edition | Both | ||||
| Operating System | Windows 11 | ||||
| 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 |