Changing start date for _day_of_year

[allnutt16]

Is there a way I can change the start date for when the count on _day_of_year begins?  The default is to start at Jan-1 but my client has a fiscal year beginning of July-1.

TIA

[Francis aka khayman]

use add_months function

[allnutt16]

can you elaborate a little bit? Do I need to create a separate data item for the add_months function or do I somehow incorporate it into my _day_of_year function?

[Francis aka khayman]

Ok for example today is July 2. Your start of year is July 1 so your _day_of_year should be 2 right? But because the count starts at Jan 1, the actual result is 7months + 2 days.

So why not July 2 - 7 months = Jan 2, then do the _day_of_year function?