Knowledge Drop

Can I calculate day of year in Table Calcs?

  • 5 April 2021
  • 0 replies

Userlevel 5

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.                



0 replies

Be the first to reply!