Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Calculating Fiscal Year 2003-04-04 -- Michael Ware I'm not sure what you're looking for, but if the year begins 6/1/yyyy then
for any given date the start of the fiscal year should be:
F_BOY = DATE(6,1,YEAR(DateVar)-Choose(DateVar <
DATE(6,1,YEAR(DateVar)),1,0))
The week # of that date is then
F_WeekNum = INT((DateVar-F_BOY)/7)
That week starts at:
F_WeekStart = F_BOY+F_WeekNum*7
And ends on:
F_WeekEnd = F_WeekStart + 6
Today is April 28, 2024, 9:59 pm This article has been viewed 35110 times.
|
|