` Week of year (Julian Martin ) - Icetips Article

Templates, Tools and Utilities for Clarion Developers
	Home Products Download Documentation Demos Support Articles About Buy ALL PRODUCTS Build Automator Checkbox Fixer Icetips Utilities Magic Buttons Magic Entries Magic Locks OutlookBar Power ToolBar Report Previewer SQL Templates TaskPanel Window Fixer XP Theme Xplore GOLD SUBSCRIPTION SILVER SUBSCRIPTION SOLO SUBSCRIPTION Compare Gold/Silver Products Documentation Demos Free SQL Stuff Other Free Stuff PAR2 files Tips & Tricks - NEW Icetips Blog Icetips News Icetips on Facebook Icetips on Twitter Icetips on Youtube All Articles Search articles Top Ten articles Articles by Category Video tutorials What is Clarion? Support Options Live Support Email & Mail Icetips Blog Icetips on Twitter Gold Subscription Silver Subscription Solo Subscription Recurring Subscription Compare Gold & Silver Renew Your Subscription Multiple Copy Pricing

Icetips Article

Back to article list Search Articles Add Comment Printer friendly Direct link

Par2: Week of year
2001-01-17 -- Julian Martin

> How can I determine what week no of the year we are in?

!Assumes that Week 1 is defined as 1-7 January.
DayOfYear# = (TODAY() - DATE(12, 31, YEAR(TODAY()) - 1))

!Compensates for the lack of a ceiling() which I'm sure used to be in
clib
IF DayOfYear# % 7
    WeekNo# = (DayOfYear# + (7 - (DayOfYear# % 7))) / 7
ELSE
    WeekNo# = DayOfYear# / 7
END

MESSAGE('We are now in Week Number ' & WeekNo#)

Today is November 21, 2024, 7:49 am
This article has been viewed 35211 times.

Back to article list Search Articles Add Comment Printer friendly

Lost Password

Subscribe

Gold Subscription
Buy Now

Silver Subscription
Buy Now

Solo Subscription
Buy Now

Multiple Copy Pricing

Renew Subscription

Templates, Tools and Utilitiesfor Clarion Developers

Icetips Article

Templates, Tools and Utilities
for Clarion Developers