Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I m stuck off facing the issue to get days number field. here below the scenario is
There are 365 days in common and 366 days in leap year calendar.
In qlikview there's a function called Day which gives number of days in particular month. But i want
Number of days field up to today's date .
like : if Jan month having 31 days then new field gives 1,2,3,4,5,6....upto 31 and if when Februrary month starts then in the same field it starts from 32,33,34,35,36....... and add on.
So, if i in case of previous year the new field should give the values from 1 to 365 days.
Hope you got it.
Any help will be appreciable.
Regards
Mohit
Hi Mohit,
Try using DayNumberOfYear function.
Muthu
Use the function DayNumberOfYear()
Hi ,
Use>>>> DayNumberOfYear()
Regards,
Nagajuna