# Domo Ideas Exchange - Beast Modes - First / Last Days of the Month / Week

**Problem**:

How Do I calculate the start or end date of the week or month?

**Solution:**

*Last Day of the Month:*

This is fairly simple as we can use utilize the `LAST_DAY`

function which will return the last day of the month for the provided date.

LAST_DAY(`dt`)

*First Day of the Month:*

For this we can do some simple math to subtract a specific number of days. We need to get back to day one. The `DAYOFMONTH`

function will return the day number of the supplied date. We just need to subtract one less from the date's day number

-- Author: -- Created: -- Last Modified: -- Description: Subtract the number of days of the date (except one) to get the first of the month -- 24-(24-1) => day 24 - 23 days = day 1 DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY)

*Last Day of the Week:*

Similar to the first day of the month we can utilize math to add a specific number of days to get to Saturday. There is a function called `DAYOFWEEK`

which will return a number between 1 (Sunday) and 7 (Saturday). We simply need to calculate the difference from the given date to Saturday and add that number of days.

-- Author: -- Created: -- Last Modified: -- Description: Get the last day of the week. -- This is done by getting the day of the week (1-7) and adding the number -- of days needed to equal 7 (Saturday) DATE_ADD(`dt`, INTERVAL (7- DAYOFWEEK(`dt`)) DAY)

*First Day of the Week:*

For the First day of the week we do the opposite of the Last Day of the Week and subtract days until we get to day 1 of the week.

-- Author: -- Created: -- Last Modified: -- Description: Get the first day of the week -- This is done by subtracting the day number (1-7) from the given date. -- 5 (Thursday) - (5-1) days => 5 - 4 = 1 (Sunday) DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY)

#### Hey, Stranger!

#### Categories

- 5.6K All Categories
- 12 Domo News
- 8.3K Using Domo
- 1.5K Dataflows
- 2K Card Building
- 1.1K Connectors
- 301 Workbench
- 643 New to Domo
- 78 Dojo
- Domopalooza
- 1K 日本支部