this should have been simple but...28 day reporting periods. Need a function or 2

[JNL0122]

My thanks too all of you for the thoughtful replies. With your help I did indeed have a way forward and a successfully implemented solution.


I am very grateful.

Joe

[ArviLaanemets]

In case the periods are always strictly 28 days, then (on fly, I can't test it, but I think you get the idea):
PeriodNumberForDate = Int((Date() - DateSerial(YearOf1stPeriod,MonthOfFirstPeriod,Day1 Of1stPeriod))/28) + 1
and
PeriodStartForDate = DateSerial(YearOfFirstPeriod, MonthOfFirstPeriod, DayOfFirstPeriod) + (PeriodNumberForDate -1)*28

[Welshgasman]

My thanks too all of you for the thoughtful replies. With your help I did indeed have a way forward and a successfully implemented solution.
I am very grateful.

Joe

So please share, as these forums are for helping others as well?
Perhaps your issue could help someone else.?

Try to give back.