Formulas

Hi, I am trying to replicate payout from server. The server calculates 34.9345 as 34.94 but on airtable it gets rounded off as 34.93 What should I do to make sure it gives the same value 34.94? Thanks in advance Regards, Gokul

Hi, Trying to add Minutes to a DateTime seems not to work when the minutes comes from another column. Col1 : DateTime Col2: Duration in Decimal (ie: 3.5 for 3h30m) Col3: DateAdd(Col1,Col2*60,‘minutes’) Result: Col3 = Col1 If instead of using Col2 in the second parameter, I use a constant value (ie:210), then it works. If I create a Col4 as a formula of Col2*60 and then use Col4 as the second parameter of DateAdd, then it’s also not working. Am I doing something wrong? Cheers, Berni

For us newbies, is there a place where users are posting tips and techniques? For example, I finally came up with a formula to determine someone’s age if you have their date of birth. DATETIME_DIFF({D.O.B.}, TODAY(), “days”) / (-365) Anyway, just thinking that there are a lot of experiences users who might want to share their own tips.