Sorting by week of Order Date

ramsay18477 · 2010-02-15

Hi All,

I've made a report to display open orders from the Sales Header table sorted by Order Date.

But, I want to sort and do the group totals by the week number of the order date on the report.

The week number is not a field in the table but Iam using the function DATE2DWY("Order Date",2) to display the week number.

Can anyone please guide ?

Thanx a lot in advance.

ara3n · 2010-02-15

Take a look at virtual table "Date"

Use this table as dataitem and filter it to show week number only. Then use the Start and EndDate field to filter your open orders to print underneath it.

sendoh · 2010-02-16

for this cases I use "integer" dataitem it's much more easier since you use this DATE2DWY("Order Date",2) and on my experience is much faster.

ramsay18477 · 2010-02-16

Dear ara3n,

Thanx a lot for your advise.

Use this table as dataitem and filter it to show week number only

I dont have week number as a field on the Sales Header table.

Please confirm if Iam on the same page as you.

Dear sendoh,

Thanx a lot to u too for your advise.

for this cases I use "integer" dataitem it's much more easier since you use this DATE2DWY("Order Date",2)

Can you please explain in detail ?

Thanx again to both of u.

ara3n · 2010-02-16

ramsay18477 wrote:

Dear ara3n,

Thanx a lot for your advise.

Use this table as dataitem and filter it to show week number only

I dont have week number as a field on the Sales Header table.

Please confirm if Iam on the same page as you.

The date table has also start and end date that you will use to filter on posting date.

Then use the Start and EndDate field to filter your open orders

ramsay18477 · 2010-02-16

Hi ara3n,

Thanx again.

I would like to know how to view the Date table like you have displayed in your previous reply. Because I cannot find the Date table or table id 2000000007 in my Object list of tables ?

David_Singleton · 2010-02-16

ramsay18477 wrote:

Hi ara3n,

Thanx again.

I would like to know how to view the Date table like you have displayed in your previous reply. Because I cannot find the Date table or table id 2000000007 in my Object list of tables ?

just create a form based on this table.

Sorting by week of Order Date

Answers

Categories