Days of the year 1

[rudolfelizabeth]

According to microsoft this should return the days of the
current year(366 or 365)
I entered it in a query no results

Aliasdays: Format(Now(),"y")

 

[HarleyQuinn]

That should return the number of the current day of the year (on my machine 245).

You might want to check the value of the day for 31/12/TheCurrentYear to achieve what you want.

Hope this helps

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

 

[HarleyQuinn]

Forgot to include this, but an example would be:

Format("31/12/" & Year(Now),"y")

Hope this helps

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

 

[tsm1993]

Try this:

Format("12/31/" & Year(Now()),"y")

 

[rudolfelizabeth]

Thank you.