Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Thanked 0 Times in 0 Posts

    DateSerial Friday (CR9)

    How to print Week Ending: Friday on the Report where Friday is always a following Friday to the day you are opening file.
    I remember using DateSerial function but I forgot how.
    Any ideas? Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: DateSerial Friday (CR9)

    Is CR Crystal Reports? I don't know which functions are available there. In VB/VBA, you'd use

    Date() + 7 - Weekday(Date(), 7)

    If the date is a Friday, this will return the date itself, otherwise the first Friday after the date. If you want to return the first Friday after the date on a Friday too, use

    Date() + 8 - Weekday(Date(), 6)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts