Converting date to week

[Luhrern]

In a query I am using a date field with the following format 07.11.2002 - I want to convert this to week e.g. 45.2002. Is this possible, and what functions are useful ?

Regards

Luhrern

 

[DanJR]

Hi there,

try using an expression like this:

format([date_field],"ww&quot & "." & year([date_field])

The "ww" part of the format function returns a number between 1 and 53.

hope this helps
Cheers,
Dan