Forum Discussion
Solved
Today as a number dynamically
Today as a number = DATEDIFF ( DATE ( 2023, 1, 1 ), TODAY (), DAY )+1 I am using the above to work out today as a number i.e. the day number for this year. So for example the 4/9/23 is day 247. ...
Hello Jak27136 ,
try this
Today as a number = DATEDIFF ( DATE (YEAR(TODAY()) , 1, 1 ), TODAY (), DAY )+1If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Idrissshatila
Super User
Super UserHello Jak27136 ,
try this
Today as a number = DATEDIFF ( DATE (YEAR(TODAY()) , 1, 1 ), TODAY (), DAY )+1
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡