jasiri - profile

jasiri · Jan 30, 2025

Hi all,I have some entries in my data table for multi-year contracts. I have one field that shows the number of months the contracts span (using the formula (DATETIME_DIFF({End}, {Start}, "days"))/30). I used days instead of months because if a contr...

jasiri · Jan 31, 2025

Thank you - that worked very well, but there was one issue:Not all of the contracts start in the same year and I actually need the columns to be "months in 2024", "months in 2025", "months in 2026" (rather than first year, second year, etc.) As of ri...

User Statistics

User Activity

DATETIME_DIFF between start and end date in months for different years

Re: DATETIME_DIFF between start and end date in months for different years