Need help in work week

[lsy]

i would like to querry a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when go to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this?

 

[Morten R]

Hi, if you want to show the result of your query as this format: MM.YY, u need to change the property of the field in the query,in the format field in property put in this: YY.MM or MM.YY, i dont knowe what dae format u use.

God luck

M.

 

[lsy]

Hi, if you want to show the result of your query as this format: MM.YY, u need to change the property of the field in the query,in the format field in property put in this: YY.MM or MM.YY, i dont knowe what dae format u use.

God luck

M.

i'm looking for work week not month... i try using datepart... but it unable to show me "ww yyyy" in one record.
thanks.