RE: RPG Embedded SQL Last day of week # nn?

I supposed you could write some SQL functions to back track but I think that would be as much work as joining in a DATE_DIM for what you want.

With this code you can create your own DATE_DIM and then add an index over any reasonable column then you can get want you want.

http://code.midrange.com/6831435c6a.html
http://code.midrange.com/2a9cd4630b.html

This calendar contains adjustments to were week 53 falls into what year for our accounting purposes. You will have to make adjustments to this if you don't like that option.


Thanks, Matt

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin
Sent: Wednesday, January 20, 2016 2:37 PM
To: RPG programming on the IBM i / System i
Subject: RPG Embedded SQL Last day of week # nn?

Is it possible to get the date of the Friday of the week when we know the week #?
--
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.