In which of the following scenarios is DATE_IN the optimal date function to use? Select ALL that apply.
- To find values in the last 30 days
- To find values in the current day
- To find values between two randomly selected dates
- To find values from “last week”
- To find values between the start of last month, and the end of the current month