Saltar al contenido principal

Domo University Videos

Domo

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.

  1. Create a DataFlow.

  2. Import the columns you need.

  3. 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

  1. Save the transform.

  2. Create output. 

  3. Save and run the DataFlow.