Doing a simple add 2 or 3 days to a start date.


I've tried adding in timezone same for all using GMT and America/New York UTC -5. same issues
Doing a simple add 2 or 3 days to a start date.
I've tried adding in timezone same for all using GMT and America/New York UTC -5. same issues
Lookup fields, often return as arrays, even if there is just one number. You could use a Rollup that does MAX(values), or keep the Lookup field and adjust your formula to force the Lookup to be a number
DATEADD(Start, VALUE(Days&""), 'days')
When field names are single word, you don't need the brackets.
Lookup fields, often return as arrays, even if there is just one number. You could use a Rollup that does MAX(values), or keep the Lookup field and adjust your formula to force the Lookup to be a number
DATEADD(Start, VALUE(Days&""), 'days')
When field names are single word, you don't need the brackets.
Thank You! VALUE does the trick!...weird to have to add in &"". I guess Also hard to do a search for VALUE() LOL
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.