Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
DayNumber of year always uses years based on 366 days, so a specific day of month always gets the same number assigned.
=Today()- yearstart(Today()) +1
I get 355 with Now(), look at your systemdate.
Greetings from Munich
Martina: I also get 355, but it should show 354. At least according to my calendar.
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.
I think Qlikview is calculating 29 Days for February. That is what Swuehl said, if you want exact days use the above expression suggested by Swuehl.
you can use in the expression a datefield with the Num-function:
Try using this
=DateFieldName- yearstart(DateFieldName) +1