Why Schedule Date Sorting Doesn't Reverse Between Clicks.

The Schedule Date column on the Work Orders page sorts differently than most columns. Because a single work order can span multiple days, each click uses a different representative date to determine order — so clicking twice is not a simple reverse.

 

At a Glance

 

When you click the Schedule Date column header:

 

• A single work order can include multiple scheduled dates.
• First click sorts by the earliest scheduled date for each work order (oldest first).
• Second click sorts by the latest scheduled date for each work order (newest first).
• The two clicks answer different questions — they are not strict reverses of each other.

 

Why Multiple Dates Matter

 

Many jobs span several days. To sort fairly, Floorzap evaluates the full schedule for each work order and uses a single representative date depending on your click — the earliest date on the first click, and the latest date on the second.

 

First Click — "When Does This Work Order First Start?"

 

The first click sorts work orders by their earliest scheduled date, oldest first. This helps you see which jobs are starting soonest.

 

#	Work Order	Scheduled Dates	Earliest Date Used
1	WO-1001	Jan 3, Jan 10	Jan 3
2	WO-1002	Jan 5, Jan 6, Jan 7	Jan 5
3	WO-1003	Jan 8	Jan 8
4	WO-1004	Jan 9, Jan 15, Jan 20	Jan 9
5	WO-1005	Jan 12, Jan 13	Jan 12

 

Resulting order: WO-1001 → WO-1002 → WO-1003 → WO-1004 → WO-1005

 

Second Click — "When Does This Work Order Last Run?"

 

The second click sorts work orders by their latest scheduled date, newest first. This highlights jobs that run the longest or extend furthest into the future.

 

#	Work Order	Scheduled Dates	Latest Date Used
1	WO-1004	Jan 9, Jan 15, Jan 20	Jan 20
2	WO-1005	Jan 12, Jan 13	Jan 13
3	WO-1001	Jan 3, Jan 10	Jan 10
4	WO-1003	Jan 8	Jan 8
5	WO-1002	Jan 5, Jan 6, Jan 7	Jan 7

 

Resulting order: WO-1004 → WO-1005 → WO-1001 → WO-1003 → WO-1002

 

Why the Order Changes Between Clicks

 

Because each click uses a different representative date, jobs can move significantly in the list:

 

• WO-1004 starts on Jan 9 (middle of the pack on the first click) but runs through Jan 20, so it rises to the top on the second click.
• WO-1002 starts early on Jan 5 (near the top on the first click) but ends on Jan 7, so it drops to the bottom on the second click.

 

What This Means in Practice

 

Use the click that matches what you're trying to find:

 

• If you're scheduling crews for the next few days, use the first click to see which work orders begin first.
• If you're managing resource commitments over time, use the second click to spot work orders that extend the longest.

 

Why the Sort Doesn't Just Flip

 

It's common to expect the second click to be a simple reverse of the first. Because multi-day work orders use different representative dates — earliest vs. latest — the sequence can change in non-obvious ways. This is intended behavior, not a bug.