Results 1 to 2 of 2

Thread: Week to Date

  1. #1
    Join Date
    Jun 2008
    Location
    Leyland in NW England, UK
    Posts
    19

    Question Unanswered: Week to Date

    Can anyone tell me the formula I need to use in order to retrieve sum of integer field (Claims_Made) for week to date - .

    I know there's weektodate function but it runs Sunday to Saturday so what code so I need to use to get Friday to Thursday instead?

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Introduce an integer variable to subtract from todays date.
    You can use an if statement using the function DayOfWeek.
    Subtract incrementing number from today's date and if the resulting WeekOkDay is 6 then that's Friday date from today. use that as fromdate for your parameter.

Posting Permissions

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