Trying to figure out why I get the wrong day of year.
I have a text box where I put this: =DayNumberOfYear(Start)
Start is a date ield that contains the start date for a production batch. It would typically look like: 14.12.2011 12:00:00
I have tried it with the Now() and Today() function as well.
= 'dayYTD: ' & DayNumberOfYear(Now())
Given todaysdate: 20.12.2011 it should return 354, but it return 355.
Can any one please ket me in on why?
Swuehl: It get 354 with your code yes, but how to use it if I have a field with date.
Like my start date. I want to get the correct day of year for that given date.