Solved: Set date picker to first day of current year? - Page 2

KerryIBCLC · 02-22-2022 06:53 AM

Hello all,

How do I set the date picker to default to the first day of the current year?

I've tried:

DATE("1/1/YEAR(TODAY())")

This shows as a valid expression but the date picker is blank when using it.

Thanks 🙂

Marc_Dillon

Oh, gotcha.

Yah that expression won't work, because expressions don't evaluate if they are inside of quotations. You can try concatenating the values.

DATE("1/1/" & YEAR(TODAY()) )

The ampersand is shorthand for the CONCATENATE() expression.