Knowledge Drop

Can I calculate day of year in Table Calcs?

  • 5 April 2021
  • 0 replies
  • 233 views

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!

Reply