Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    JNL0122 is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    8
    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

  2. #17
    Join Date
    Apr 2017
    Posts
    1,775
    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

  3. #18
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,258
    Quote Originally Posted by JNL0122 View Post
    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.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-06-2020, 08:21 PM
  2. Simple SETVALUE function
    By fishhead in forum Access
    Replies: 2
    Last Post: 07-21-2020, 05:53 PM
  3. Simple passing into function question
    By Ruegen in forum Programming
    Replies: 3
    Last Post: 07-24-2014, 11:23 PM
  4. Replies: 4
    Last Post: 05-25-2014, 02:01 AM
  5. Need Help with Simple VB Function
    By nrage21 in forum Programming
    Replies: 2
    Last Post: 09-21-2010, 09:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums