Date arithmetic - Adding a Date and a number

[romaintailhurat]

Some date arithmetics are already implemented in Trevas JS.

In the case of subtraction between two dates, the return type is an integer (eg seconds).

We would like to implement addition and subtraction between a date and a number with another date as the return type.

For example, with a DATE variable of 2023-09-29, we would like the resulting behavior:

DATE + 3 → 2023-10-02

[romaintailhurat]

The VTL spec doesn't allow for this kind of behavior:

[romaintailhurat]

Maybe we could a custom operator that wraps a call to a underlying engine function? Or is it too much of a hack?

[NicoLaval]

Hi,

Instead of the 3 integer you certainly want to add a duration to the date, enable you to specify that your 3 is 3 days.
Didn't find a way to do it for now: Date + Duration -> Date

This subject can maybe be discussed this week during Roma meeting.

Please link your issue to the https://github.com/VTL-Community/VTL-Community issues.

[romaintailhurat]

👉 VTL-Community/VTL-Community#38