calculate a week

[Silvio.Falconi]

Dear Friends,

I have a date sample 16.10.2015

I wish Know the week where there is this date

sample : from 12.10.2015 to 17.10.2015


exist a function give me this ?

thanks in advance
I need this because I must calculate how many times a teacher is on a specific classroom

[driessen]

The DOW() function?

[Silvio.Falconi]

Sorry,
DOW() returns the day of the week as a number between zero and seven.

I want the function return me the date of first day of the week and the date of the seven day of the week of the date past

sample if I have 16.10.2015 -----> give me 12.10.2015 and 18.10.2015

I hope you undestood me

[driessen]

Yes, that's right. But by using the function DOW(), you can get your goal like this :

Code: Select all

FUNCTION FirstLastDOW(dDate)

   LOCAL cDow   := DOW(dDate) // 1 = Sunday / 2 = Monday / ... / 7 = Saturday
   LOCAL cFDate               // last Monday before dDate
   LOCAL cLDate               // first sunday after dDate

   cFDate = IF( cDow = 1, dDate - 6 , IF( cDow = 2, dDate, dDate - ( cDow - 2 ) ) )
   cLDate = IF( cDow = 1, dDate, dDate + ( 8 - cDow ) )
   
RETURN({cFDate,cLDate})

Good luck !!!

[zekasan]

wom(date()), i read your post now

[Silvio.Falconi]

FirstLastDOW(dDate) RUN GOOD ONLY
in Italy we have the first day monday and the six saturday ( seven sunday)