Please tell me how to tell weeks in between two dates in..

building reports webintelligence
1

…Web Intelligence XI
Hi
I see a daysinbetween and monthsinbetween but do you have a way to do a date difference to tell the weeks in between two dates
Thanks for all you help in advance
:hb: :nopity:

britchotte (BOB member since 2010-05-25)

2

Mein Gott!!!
No one could figure out that you take the days in between the two dates and just divide by 7 and round that number so no decimals appear.
Thank you anyway. I wasn’t testing anyone. I just figured it out for myself. I feel like a doofus :flush:

britchotte (BOB member since 2010-05-25)

3

I doubt that you did not get a reply because no one could figure it out, there was very little time between your first post and your follow-up. To be honest, I just now saw the post. :yesnod:

REB01 :us: (BOB member since 2004-11-29)

4

Create Variable like below

Variables:

1.Firstday_of_Week

=RelativeDate(CurrentDate();-DayNumberOfWeek(CurrentDate()))
or
=RelativeDate(LastDayOfWeek(CurrentDate());-6)
  1. Lastday_of_week
=LastDayOfWeek(CurrentDate())
  1. DaysInWeek
=DaysBetween([Firstday_of_Week];[Lastday_of_week])

I hope this is your requirement

Rajubollas :india: (BOB member since 2009-09-04)