It's currently 19:55 on the 21st december in New Zealand. Why does this calculation return a date of the 20th december and the time as 18:55? Surely it can't be that hard to show the correct date for the country you're in?
It is currently the 18th Dec in NZ. The field I have called TodayNZ is a calc "Today()". It is formatted as NZ time zone. Is there any reason why it comes up as the 17th Dec?
See if this clears it up. ("test" is the duration field).IF(test, CONCATENATE( INT(test/3600), " hours " , INT(MOD(test,3600)/60)," minutes ", MOD((test-3600),60), " seconds " ), "")
Hi - assuming the 14 days is either before or after the start date try this ...IF({Orientation Complete Date}, "Complete", IF({Start Date}, IF(ABS(DATETIME_DIFF(NOW(), {Start Date},"Days")) < 15 , "Almost Due", "Overdue"),""))
The error is possibly coming from the {Formatted Date} field that I'm assuming is something like this :DATETIME_FORMAT({your date name},"YYYY-MM-DD")If so change it to :IF( {your date name} , DATETIME_FORMAT({your date name},"YYYY-MM-DD"), "")
Hi Ken - calculating days months and years between dates looks like it should be simple but the more you look the more you realise the complexity of it. I have my doubts that it's possible using an airtable formula field.Each month has a different nu...
