TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: PETER VAN DER LEE
date: 1995-10-02 09:24:00
subject: convert day to weeknumber

I have sales information like order-header and order-details gathered in two 
databases. The order-header containes the sales date.
Now I want to have an overview/report/statistics based on a weeknumber. So I 
think about creating a new table in which I convert the normal date to a 
weeknumber. Who has already invented the wheel the make this conversion???
CU on screen,
from Apeldoorn, Holland
p.vanderlee@dosgg.nl
--- MBM v3.40b
---------------
* Origin: Zo'n miljeu, wa kostat nouw. (2:500/116.6271)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.