Skip to main content

I have venue table, with venues and associated travel times (in Number format). Another table has programs, with start date/time (in Date format). The program table links to the venue table, and there is a Lookup field with travel times. I would like to create a new field, "departure time", which is the start time minus the departure time. When I use the following formula:

DATEADD({Start Date},-{Travel time},"hour")
I get an error. To check the formula, I created a new field that is Number field, where I copied the numbers in the Lookup field. The formula then worked.
 
I am wondering if I can convert the lookup field directly into being a number so that the formula will work.
Thanks.

Hmm, I hit the same issue you did, then I converted my formula to this:

 

DATEADD(
Date,
{Number (from Table 2)} + 0,
'days'
)

 

Which seemed to fix it:


I have no idea what's happening heh but hey worth a shot to see whether it fixes it on your side!

Link to base

---
I also then tried removing the +0, and it didn't error out anymore, but it also didn't add the number?  I'm baffled

Reply


Terms & Conditions