Sort the data weekly

[Former Member]

Hi,

I need to get the ticket data for the last 6 months and then sort them by week and then by the Product ID. The date field is in epoch format. Whats the best way to do it?

Do I need to create a formula on date field and then group on it?

Example:

Week 10/12/2008

IPW - 25

EPA - 37

WER - 14

Week 10/19/2008

IPW - 22

EPA - 29

WER - 13

Week 10/26/2008

..

..

and so on

Regards,

Vamshi

[Former Member]

Hi Vamshi

1. Create a formula to convert your EPOCH date as:

DateAdd("h",<Your EPOCH Date>,#01/01/1970#)

2. Create a group based off this formula and while creating the group, select the "for each week" option under the "The section will be printed :" in the Insert Group dialog box.

3. In the Record Sort expert add the Product Id field to the "Sort Fields" list.

This should solve the problem.

Regards

Nikhil Sabnis

[Former Member]

Thanks Nikhil. I will try and let you know the result.

Vamshi

[Former Member]

Hello Nikhil,

The sorting worked as you said. However for converting the epoch time, I had to use a different formula.

Thanks for your help.

Vamshi