Can I calculate day of year in Table Calcs?

[LookerExperts]

Knowledge Drop

Last tested: Jan 21, 2019
 

Yes, you can use the following expression:

diff_days(date(extract_years(now()), 01, 01), now())+1

Note the +1, without the additional +1 you will only be counting days between Jan 1st and Today, not counting Today.

This content is subject to limited support.