This content has been marked as final. Show 7 replies
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?