Count the actual number of days - in a year

[Tiger1]

What would the expression look like to count the number of days in the year to date? This should change according to the day…

[MultiTech]

I just had to make this one for myself, here ya go:

FLOOR(TOTALHOURS(
[DateTime] - DATETIME(CONCATENATE(“01/01/”, YEAR(DATE([DateTime])), " ", “00:00:00”,))
)) / 24

This assumes you’ve got a DateTime column.

[Tiger1]

Can I create a virtual date column to use?

MultiTech_Visions

February 8
I just had to make this one for myself, here ya go:

FLOOR(TOTALHOURS(
[DateTime] - DATETIME(CONCATENATE(“01/01/”, YEAR(DATE([DateTime])), " ", “00:00:00”,))
)) / 24

This assumes you’ve got a DateTime column.

[MultiTech]

The following gives you the day of the year (for today):

FLOOR(TOTALHOURS(
NOW() - DATETIME(CONCATENATE(“01/01/”, YEAR(Date(Now())), " ", “00:00:00”,))
)) / 24

Gave me the following result when I tested it:

Which is the day of the year for the date when I ran that test:

[Tiger1]

Thank you -i will try this out today. Thanks again…

[MultiTech]

You’re welcome; just a few hours before you posted your question I was figuring out how to do that for an app.

[Tiger1]

Ha. Was meant to be! Thanks again…