How to sort purchase orders by date for better forecasting?

Topic summary

Main topic: Forecasting purchasing by month using historical purchase orders (P.O.s).

  • The poster wants to analyze past orders by month and needs to sort P.O.s by date to enable this.

  • They report difficulty sorting purchase orders by date and ask for a solution.

  • No software/system is specified (e.g., ERP, spreadsheet), and the data format is unknown.

  • No examples, attachments, or code are provided; the issue description is brief.

  • Technical terms: “P.O.s” refers to purchase orders; “forecasting” means estimating future buying needs based on historical data.

  • Status: No responses or solutions yet; the discussion is unresolved and open.

  • Unanswered questions: What tool or database is being used? How are dates stored/formatted? Is the goal simple date sorting or grouping by month for aggregation? What constraints (filters, fields) apply to the report?

Summarized with AI on February 12. AI used: gpt-5.

I am looking to forecast buying by looking at what I have ordered in the past, by month. I am having trouble sorting P.O.s by date. Does anyone have a solution?