YEAR

YEAR helps you extract the year from a date in DBSheet formula fields and return a four-digit year. It provides the tools you need to calculate year values directly from your data, making your work more efficient and helping you accomplish tasks with ease. With YEAR, you can create a formula field, enter a YEAR formula, use flexible parameter input, combine it with other functions such as IF or AND, and have results calculate immediately and refresh automatically when source data changes or after data import. Whether you're building formulas for date-based records, troubleshooting parameter or data type errors, or testing formulas before applying them more broadly, YEAR helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53