[
https://issues.apache.org/jira/browse/NIFI-15658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Scott updated NIFI-15658:
---------------------------------
Component/s: Core Framework
Extensions
> Add datePlus and dateMinus functions to NiFi Expression Language for date
> arithmetic
> ------------------------------------------------------------------------------------
>
> Key: NIFI-15658
> URL: https://issues.apache.org/jira/browse/NIFI-15658
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework, Extensions
> Affects Versions: 2.8.0
> Reporter: Richard Scott
> Assignee: Richard Scott
> Priority: Minor
> Time Spent: 10m
> Remaining Estimate: 0h
>
> NiFi Expression Language provides {{toDate()}} for parsing values into a
> {{{}Date{}}}, but there is no simple built-in way to then add or subtract
> time from that {{{}Date{}}}.
> Currently, users wanting to shift a parsed date must often convert the
> {{Date}} back to a numeric value, perform arithmetic in milliseconds, and
> then convert or format the result again. This is awkward and makes common
> date operations harder to read and maintain.
> For example, users should be able to write:
>
> ${myDate:toDate("dd-MM-yyyy"):datePlus("1 week"):format("dd-MM-yyyy")}
>
> instead of relying on number-based date arithmetic after parsing.
> Proposed new functions:
> * {{datePlus(String duration)}}
> * {{dateMinus(String duration)}}
> Supported units:
> * years
> * months
> * weeks
> * days
> * hours
> * minutes
> * seconds
> The duration argument should be validated strictly, for example:
> * valid: {{{}"1 day"{}}}, {{{}"2 weeks"{}}}, {{"3 months"}}
> * invalid: {{{}"B weeks"{}}}, {{{}"1 dog"{}}}, {{"ten days"}}
> Both functions should operate on and return {{Date}} values so they can be
> chained naturally with existing date-related Expression Language functions
> such as {{{}format(){}}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
