Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
DayNumber of year always uses years based on 366 days, so a specific day of month always gets the same number assigned.
Try:
=Today()- yearstart(Today()) +1
edit
Hi, Dan,
I get 355 with Now(), look at your systemdate.
Greetings from Munich
Martina
EVACO GmbH
Martina: I also get 355, but it should show 354. At least according to my calendar.
Dan
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.
Dan
Hi,
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.
Regards,
Jagan.
Hi, Dan-Ketil,
you can use in the expression a datefield with the Num-function:
=Num(Datefield)-yearstart(Datefield) +1
Greetings from Munich
Martina
EVACO GmbH
Try using this
=DateFieldName- yearstart(DateFieldName) +1
Regards,
Jagan.