This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My data is comprised of tickets from the beginning of time. It is updated each day but we only want to return the previous Friday until the current day. For example: Today is Monday February 12th. When my flow is ran it should only return data from Friday February 9th until now. The date column is in a format of Month Day Year: 2/12/2018.
This will give you the date of the previous Friday for each date in your file, and then filter to those records since the previous Friday. This workflow keeps the past 8 days if Today is a Friday. You can adjust that in the filter though if you expect to only keep Today's records if it is a Friday by lowering to 7.
I almost have it working. My only issue I am running into is I need to pull everything since last Friday including Friday. With your formula and filter I am getting everything since Saturday Feb 10th. If it can include Feb 9th too it will be solved.