I think you can accomplish what you want with the ILE CEE date and time

Basic steps are:

1. Convert your non-Lilian dates to Lilian dates (CEEDAYS API)

2. Subtract your ending Lilian date from your starting Lilian date.
This will give you the number of days between the two dates.

3. If the difference is > 7 divide by 2 to determine the number of

You may need to do some offset work based on your Saturday being the
first day of the week requirement. The CEEDYWK API will give you a
numerical representation for a day of the week.

CEEDYWK Your Value

1 7 Sunday

2 3 Monday

3 4 Tuesday

4 5 Wednesday

5 6 Thursday

6 7 Friday

7 1 Saturday


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tomasz Skorza
Sent: Thursday, April 07, 2011 6:58 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Calculate diffrence between dates - weeks - but not so simple


I need to create an algorithm which allow me to calculate diffrence
between two dates but assumption

is that first day of week is SATURDAY, and week going from saturday to

So if first date is 2011-03-28 - monday, then for second date from
2011-03-29 to 2011-04-01

algorithm should return 1 (week), but for 2011-04-02 - saturday
algorithm should return 2 (weeks).

Have you any idea?

I tried many posssibilities and something is wrong, depend on start and
stop dates sometimes result

is as I expect sometimes not ...



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].