In which of the following scenarios is DATE_STARTOF the optimal date function to use? Select ALL that apply.

1. To find values in the last 30 days
2. To find values in the current day
3. To find values between two randomly selected dates
4. To find values from “last week”
5. To find values between the start of last month, and another given date

Correct Answer:

• To find values between the start of last month, and another given date