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.
... View more