How to get current day number (e.g today is day 291 out of 365 days)

[Anonymous]

Hello,

I am trying to get the exact day number as of today from day 1 of year 2017.

I used this string for getting the current  day number in current month:

Day(Date(today()))

But string - Year(Date(today())) does not do the trick. Hope someone helps me.

Thanks a lot!

Joy

[oknotsen · Accepted solution]

Hi,

I think what you need is this function:

daynumberofyear - script and chart function ‒ Qlik Sense‌

daynumberofyear ‒ QlikView

Note that you can also remove the date() function from your expression.

[Anil_Babu_Samineni]

Year(Today()) returns number only.. When we add Date() as always it takes as String

[pradosh_thakur]

may be this

Today() - YearStart(Today())

[prma7799]

Try like this

=DayNumberOfYear(Today())

[Anonymous]

wow this works!

I used (DayNumberOfYear(today())) Thanks a lot Onno!