Hey @rjp this can be done using a formula field
In this example, I’m using a formula field Created At + Duration to add the Duration field to the Date Time in created at
The formula look like this:
TODATE( {created at} + TIME(0, 0, {Duration} ) )
There’s 3 parts to this.
Firstly, all Noloco formulas work the same way they do in Excel, so typically you can search for similar solutions in excel.
To add time to a date time in excel, you simply add the time in minutes.
Do 12/02/2024 + 90 would be 12/02/2024 01:30
So we can do the same, but we first need to convert the duration (which is stored in seconds) to minutes, or a time field for even more convenience.
TIME(0, 0, {Duration} )
This passes the Duration field into the seconds argument of the TIME function.
{created at} + TIME(0, 0, {Duration} )
This then adds that time to the created at Date Time.
Finally, you need to convert that date value back to a Noloco Date
This is mentioned in our guides on using Dates in Formulas
TODATE( {created at} + TIME(0, 0, {Duration} ) )
You can replace created at and Duration with your own fields