Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
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 November 21, 2024, 8:22 am This article has been viewed 35204 times.
|
|