Number of week in the year for the given date

[Former Member]

In powerbuilder 11.2 , How can find the number of weeks  in the year for the given two date  '20-01-2016' to 20-11-2016';

Please any help would appreciate

Pol

[Former Member]

What is your definition for week?

If we take ' Wednesday 06-01-2016' to Wednesday 20-11-2016';

This are

a) 14 days

b) and it spans from week 1 to week 3,

c) but it covers only one complete week (week 2)

So is it

a) 2 weeks

b) 3 weeks

c) 1 week ?

and in case of b and c: when does your week start? Sunday or Monday? That differs depending where you live.

KR Ludwin

[Former Member]

Hi Pol,

How about DaysAfter(date1,date2) / 7?

Neil

[arnd_schmidt]

PFC has some code that helps

http://pfc.codeplex.com/SourceControl/latest#12.6/pfcapsrv/pfc_n_cst_datetime.sru

and here is some "short version".

Obtain the week of the year - Real's PowerBuilder How-to

hth

Arnd