0

Return the start date of each week

Is there a function or combination of functions that will return the start date of each week?  For example, if the day were to be anytime between Sunday 10/14/2018 to Saturday 10/20/2018, the function would return Sunday 10/14/2018. 

Again, if it were anytime between Sunday 10/21/2018 to Saturday 10/27/2018, it would return Sunday 10/21/2018 and so on and so forth.

 

Thanks.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • To return sunday of any week per day you can use this formula expression:

    formatDate(addDays($currentDate,(1-weekday($currentDate))),'MM/dd/YYYY')

    Reply Like 2
  • You can replace $currentDate with any Date field as below:
    formatDate(
    addDays(Sales.Date.Day,(1-weekday(Sales.Date.Day)))
    ,'MM/dd/YYYY')

    Reply Like 1
Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 181Views
  • 1 Following