I am not too sure what poibt you are trying to maje but i belive you have to use the year of the date as well
Maybe if you posted the sql it might help
Sent via the Samsung GALAXY S® 5, an AT&T 4G LTE smartphone
-------- Original message --------
From: Booth Martin <booth@xxxxxxxxxxxx>
Date: 2/20/2016 16:24 (GMT-05:00)
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Subject: rpg Embedded SQL: date/week order by
As you all can no doubt tell, I am enjoying SQL!
In the category of... it'd be nice to fix if its easy but its not worth
a candle...
I am displaying data in order by date, newest first. Works fine when I
am displaying every day. However when I group by week or month it shows
last year December to June first, then this year February to January
because week 52 is greater than week 1. month 12 is greater than month
1. I can not figure out how to order by date because date is not a
group by field.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
