Number of Days in Year

building reports webintelligence
1

Hi

Can any body help me , how to find the total number of days in a year(Date input is from prompt).

Thanks in advance

BI.User (BOB member since 2007-05-22)

2
  1. Retrieve the year part yyyy alone from the entered date.
  2. If Mod(yyyy/4)=0 then 366 else 365.

Does that help?

P.S: Above is the pseudocode .

Jansi :india: (BOB member since 2008-05-12)

3

Would need to take into account years divisible by 100 are not leap years, unless divisible by 400.

How about something like this?
=DayNumberOfYear(ToDate(Concatenation(“12/31/”;FormatNumber(Year([Today]);"#"));“MM/dd/yyyy”))

chris465 (BOB member since 2008-04-29)