Week of the year

[megias]

Hello,
I have a field date and I need to get the week the date belongs.
example: date= DD/MM/YY
If I have 07/01/02 I need a formula that gives me the value 2, because that date belongs to the second week.
How can I do it?

Thank you very much.

Juan M.

 

[synapsevampire]

If 7/1 is the second week, this means that some date in late June is your start of year???

My first suggestion her is to ALWAYS build a period table in the database.

This table holds all dates with various attributes, such as workweek, fiscal workweek, weekday, holiday, month, etc. Now you can always join to it, this is a standard practice in a data warehouse.

Anyway, from within Crystal, you might use the datepart function:

DatePart ('ww', {MyTable.MyDateField}, <firstDayOfWeek>, <firstWeekOfYear>)

You can then adjust the workweek returned based on your fiscal year (add or subtract 26 to it, or however it works for you).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[megias]

Thank you very much.

It has work perfectly.

Juan M.