Hi,

As 2015 started, my DayOfYear () numbers were reset. So, as an example, 01/15/2014 is the same as 01/15/2015. Any clue on how could I continue counting through 2015 without reseting DayOfYear () to the beginning?

Tnx.,

IJ

Hi,

As 2015 started, my DayOfYear () numbers were reset. So, as an example, 01/15/2014 is the same as 01/15/2015. Any clue on how could I continue counting through 2015 without reseting DayOfYear () to the beginning?

Tnx.,

IJ

Hi there,

I don't think I quite understand the issue. DayOfYear() is a count of the days from the beginning of the year to the date specified. Here is the FileMaker Help on it: DayOfYear

Are you looking for another command that gives you the Day Name? That would require the DayName() function.

I hope this helps

Hi,

I started a Gantt chart last year for projects that continue through 2015 and beyond. The "X" axis (day calculation) is based on DayOfYear() decimal number. What's happening now is that 2015 data in the Gantt chart is concurrent with 2014, since the decimal number for dates in 2014 are the same as to 2015. All I need is the DayOfYear () decimal number to continue counting over 365 days. I used an If() function to ad 365 to DayOfYear() number when the date year was 2014 but the problem continued. So I'm wondering if there's a function or a way to make DayOfYear to continue counting over 365 days.

Dates are just a formatting option for a series of numbers, e.g.

31 Dec 2014 is 735598.

1 Jan 2014 is 735599.

2 Jan 2015 is 735600

etc, etc.

Is there not a solution to your problem that can be based on these numbers rather than dates, per se?

I'd be very interested in how you are approaching the Gantt chart issue ...........

Paul

DayOfYear will ALWAYS deliver the answer 13 for January 13th; that is what you are asking for with this calculation—how many days is whatever date you choose since the beginning of the year it is part of. Asking it to deliver a cumulative result that includes some days in a previous year is not going to happen by itself, although you could construct an elapsed time calculate that includes this function.

totally forget DayOfYear() please. Convert everything to numbers, with GetAsNumber(Date(m,d,y)) and make your calcs on that. Create your own custom functions to do it, you'll need some for SQL too.

You can build your own DayOfYear() function, - Date(1;1;year) + yourdate and so on.