Adding an amount of days from specific colomn to the days in a date column and put the new date in a new column

Technical Help
1

I got 2 columns named :

-“Confirmation date” , format = date
-and another column named “dilevery days”, format number.

The goal is to Add the amount of days from “dilevery days” colomn to the days in “Confirmation date” column and put the new date in a new column.

i tried these formulas:
field(‘Confirmation date’) + date_interval(‘field(‘dilevery days’) day’)

field(‘Confirmation date’) + date_interval(field(‘dilevery days’), ‘day’)

and i learned that [DATEADD(field(’ confirmation date’), field(‘dilevery days’), ‘day’)] function is not suppported in baserow.

PLease give me some directions or an on point solution.

Thank you in advance.

2

Hello @ahmedsobeyh, please try this formula:

field('Date') + date_interval(concat(totext(field('Amount')), ' days'))

image
image1920×959 163 KB

1 Like
3

This is a horrible solution. adding calendar days or work days to a date are the cornerstones of any project activity. There really needs to be a formula for both. They are commonly available in most no code tools

4

Hi @alfredcoates62, welcome to the community! Please try to keep the feedback constructive instead of criticising :slight_smile:

Could you provide some further details as to why the formula mentioned by Olga would not work in your situation and what your exact needs are? The more we understand of your use case, the better we can provide a solution.