Skip to main content
Question

Edit week length

  • September 17, 2018
  • 0 replies
  • 12 views
I have a field that calculates Week Of based on the date that someone enters for each record. I have set Sunday to be the displayed date for the Week Of field using the formula:

PrevDayofWeek([Date], 0)

The problem I'm running into is if someone enters a record in on Sunday, it relates it to the previous Sunday instead of the current Sunday. This example is what I'm getting:

Date: 9/16/2018
Week Of: 9/9/2018

Week Of should be 9/16, not 9/9 but can't figure out how to change it to show the right Week Of?
    This topic has been closed for replies.

    EverettPatterso
    Forum|alt.badge.img+10
    Try this for the WeekOf formula

    If(DayOfWeek([Date])=0, [Date], PrevDayOfWeek([Date], 0))

    Terms & ConditionsAccessibility statement