Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Reporting with SQL!
You have completed Reporting with SQL!
Preview
Calculating dates are great for generating reports and dashboards that are dynamic in nature.
Documentation Links for Calculating Dates
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
the last 30 days.
0:00
How do we go about doing that?
0:01
You've already seen the DATE
function using the string of now.
0:04
This is known as a time string.
0:08
We'll look at some more
time strings later.
0:10
The DATE function can take another
argument called a modifier.
0:13
A modifier modifies or changes the time
string value passed as the first argument.
0:17
In fact, you can chain any
number of modifiers together.
0:24
Let's look at some examples.
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up