Re: Calculate diffrence between dates - weeks - but not so simple ...

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Tomasz,

Have you taken a look at DAYOFWEEK_ISO scalar function? It returns 7, if
the date is on a Saterday.

Using this in a CASE construction it is either CURRENT DATE - 14 DAYS or
CURRENT DATE - 7 DAYS.

With regards,
Carel Teijgeler


*********** REPLY SEPARATOR  ***********

On 7-4-2011 at 15:58 Tomasz Skorża wrote:

> Hi
>
> 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
> friday.
> 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 ...
>
> Regards
>
> Tomek
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> -----
> Geen virus gevonden in dit bericht.
> Gecontroleerd door AVG - www.avg.com
> Versie: 10.0.1191 / Virusdatabase: 1500/3552 - datum van uitgifte:
04/05/11
> -----
> Geen virus gevonden in dit bericht.
> Gecontroleerd door AVG - www.avg.com
> Versie: 10.0.1191 / Virusdatabase: 1500/3552 - datum van uitgifte:
04/05/11