I need to group dates for 6 months to 1 year in weeks and show data sorted by those weeks

If you have a Date-Time field the function HPART should do everything you need.

field2/Ifmt = HPART(DTfield,'UNIT',format);

For Smart Dates (usage format MDY, DMY, YMD etc.) the DATEMOV function may be used to convert the date to the beginning of the week (BOW) or the end of the week (EOW):

SD_MDY2BOW/MDwY = DATEMOV(SD_MDY2,'BOW') ;

Above sample is derived from:
"(Almost) 1001 Ways to Work with Dates in WebFOCUS"
which is available from www.aviter.com

Hope this helps,
John Price

Hi smart, is this still an outstanding issue for you? Have you tried the search on Focal Point posts and/or tech support documents?

Please see if the following online documents can give you any insights or hints.

How to create and sort by a WEEK_NUMBER field?
http://techsupport.informationbuilders.com/sps/42711061.html
Calculating the Week Number Based on the Date
http://techsupport.informationbuilders.com/tech/cof/cof_tcn_029.html
How to create a custom calender from a range of dates
http://techsupport.informationbuilders.com/sps/81191105.html

You will need to have a userid/password to access the above documents.

Hope this helps.

Cheers,

Kerry