Fiscal Year Function

[Veronica]

I'm perplexed! This seems like it should be so simple. I have a calculation field, (Current Week) that is nothing more than the "WeekOfYearFiscal" function. And yet, the only return I get is a "?".

Each week is a record so I expect to get a return of 1 thru 53 for each week of the year as I go along. Monday being the start of the week. The calculation is as follows: Current Week = WeekOfYearFiscal(7/1/2004,2)

Why can't I get a darn number returned in the field? What am I not getting about this? Thanks in advance for the help.

Veronica

[-Queue-]

7/1/2004 = 0.0035, i.e., it's not a date; it's a calculation.

Try

WeekOfYearFiscal( Date( 7; 1; 2004 ); 2 )

or in general, WeekOfYearFiscal( datefield; 2 ).

[Veronica]

Queue,

Thank you very much for your help. I thought I had done/tried this before but got an unexpected and unsatisfactory result. Come to discover, I think, the unsatisfactory result occurred because of the type of field, "Calculation" and the date/day that I attempted this. It changed all my records to the one "result" appropriate for the date I did it. Because it is a Calculation field, I wasn't able to change the prior records to the actual result for those records. Does that make sense? I changed the field to a numeric, auto-enter by calculation. That way I can change all the prior records. Next week I'll find out if this approach works. If what I did makes sense to you, do you see and easier way?

Thanks again.

Veronica

[-Queue-]

The auto-enter will work for new records, but not existing ones. You will need to update the older ones. If there is a date field on which the calculation is based, you could use that in place of the hard-coded one and make it a normal calculation field. How is that date determined? Is it based on creation date?

[Veronica]

Thanks Queue. I'll try that out.

Veronica