Yes, but a little tricky.
If you are working with the WEEK according the ISO guideline, the rule is:
Week starts always with Monday and the majority of days in the first week of
the year must be of the new year. What is for sure is January, 4th is
always in the first week.
Beginning with January 4th of the year of the week, you determine the first
day of the year, than add 7*Week Days + 4 days to get the Friday.
Set :FridayWeek = :Jan4Year - (DayOfWeek_ISO(:Jan4Year) - 1) Days + (7 *
:Week + 4) Days.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Booth
Martin
Gesendet: Wednesday, 20.1 2016 22:37
An: RPG programming on the IBM i / System i
Betreff: 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.
midrange.com
