weekofyearfiscal return 2-digit week

[burnthemachine]

this is probably an easy problem, as i'm fairly new to filemaker.

I've got a database that keeps track of an employee's working hours....

Each line in the report has the info: date, time in, time out, timelunch, timedaytotal

and at the end of each 7 day week, there's a subsummary that lists the total number of hours for that week.

now, the problem comes when sorting by week. it is currently sorting by date, and yearandweek (year and week is a calculation of "year" combined with "weekofyearfiscal"...

so, for early january 2004, i would get a value like "20047" and for a week in late 2003, it will give me "200341"... so filemaker sorts my 2003 date as being greater than my 2004 date because the number of digits is greater.... so i'm wondering if there is a way to return a weekofyearfiscal with a double-digit date, so that 20047 becomes 200407....

thanks in advance for your help!

[burnthemachine]

nevermind, i figured out a solution... not sure if it's the best one, but here it is:

Year(date)&Right("00" & justweekofyear, 2)

"justweekofyear" is a text file containing the result of the function weekofyearfiscal....

i wonder if i can put that function right into the above calculation......

yup, even better

Year(date)&Right("00" & WeekofYearFiscal(date,2), 2)

that's prettier.

thanks anyway guys....