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

    Wrong day of year

    Dan-Ketil Jakobsen



      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?