P
PPCO
I have a shipping schedule, and I want to group orders by date. I have an IF
statement that says that if an order is older than today, than to put it as
"Backordered", otherwise group under the appropriate ship date. It worked
fine until orders from 9/10/2008 started showing up and the grouping would
look like this:
Backordered
9/10/2008
9/11/2008
9/5/2008
9/6/2008
9/7/2008
I have the field sorted by ascending in my query--I'm sure the problem is
there with having text show up in a date field. Any ideas how to get it to
properly order?
statement that says that if an order is older than today, than to put it as
"Backordered", otherwise group under the appropriate ship date. It worked
fine until orders from 9/10/2008 started showing up and the grouping would
look like this:
Backordered
9/10/2008
9/11/2008
9/5/2008
9/6/2008
9/7/2008
I have the field sorted by ascending in my query--I'm sure the problem is
there with having text show up in a date field. Any ideas how to get it to
properly order?