I need to create a report that show sales by week for each of the preceeding 8 weeks (which I can do), and the sales for each of those same weeks last year (which is the hard part). Anyone have a saved search formula or piece of script that does something like that? I'm thinking it may have to be scripted, some way to find the week number of the year eight weeks ago, then show sales from that particular week number the year before?

Hi Amanda. Try using the trunc function. https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/TRUNC-date.html#GUID-BC82227A-2698-4EC8-8C1A-ABECC64B0E79

thanks! i ended up writing a script and using the moment.js library, it was pretty simple.