Beginning and End of Week
Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=beginningendweek
You can create a new column in your DataFlow that shows the beginning and end of the current week.
-
Create a DataFlow.
-
Import the columns you need.
-
Add an additional column with these functions:
-
adddate(curdate(), INTERVAL 1-DAYOFWEEK(curdate()) DAY) For
WeekStart
-
adddate(curdate(), INTERVAL 7-DAYOFWEEK(curdate()) DAY) For WeekEnd
-
Save the transform.
-
Create output.
-
Save and run the DataFlow.