Skip to main content

Is there a way to do an advanced search and group by a date, but in weekly buckets?

We are in IEE.

@TosohLBlum 

I don’t believe there is a direct way in the Search window, but you could create a custom field (Read Only) with the ISO Week Start and then group on that.

Example using the Wanted Delivery Date from Customer Order Line: 

SELECT trunc(col.wanted_delivery_date, 'iw') AS iso_week_start,
col.wanted_delivery_date AS actual_wanted_del_date
FROM customer_order_line col

Make sure you set the custom field so it can be searched on (which is usually defaulted).

Then in your Advanced Query you can group on the ISO Week Start, like this:

 

Let me know if this is what you were looking for? 


I thought of that, but the window I’m looking at is the Machine Load per Work Center and it won’t allow custom fields.🙁


I thought of that, but the window I’m looking at is the Machine Load per Work Center and it won’t allow custom fields.🙁

Sorry about that. I don’t know of another way. 


Reply