7 Replies Latest reply: Dec 20, 2011 8:37 AM by jagan mohan rao appala RSS

    Wrong day of year

    Dan-Ketil Jakobsen

      Hi

       

      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?

       

       

      Dan