✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
    • Showing results for:
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates
    • Close
  • Brian Taylor
    Brian Taylor
    3,436 Points

    Your code challenge appears to have a broken Javascript file in it? (or at least in this instance of the virtual machine

    Posted on Jan 26, 2023 by Brian Taylor
    Brian Taylor
    3,436 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Geovani Mejia
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Geovani Mejia
    Front End Web Development Techdegree Student 7,940 Points

    Help With Reporting WITH SQL

    Posted on Sep 30, 2022 by Geovani Mejia
    .a{fill-rule:evenodd;}techdegree
    Geovani Mejia
    Front End Web Development Techdegree Student 7,940 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Katie Martens
    Katie Martens
    1,962 Points

    Counting orders from yesterday from an ecommerce database

    Posted on May 9, 2022 by Katie Martens
    Katie Martens
    1,962 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    3 Answers

  • Alessandro Pappacena
    Alessandro Pappacena
    2,589 Points

    Wrong count calculation

    Posted on May 23, 2021 by Alessandro Pappacena
    Alessandro Pappacena
    2,589 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Jason Nutt
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Jason Nutt
    Front End Web Development Techdegree Graduate 24,851 Points

    I am getting the answer expected the count to be 14....

    Posted on Oct 30, 2020 by Jason Nutt
    .a{fill-rule:evenodd;}techdegree seal-36
    Jason Nutt
    Front End Web Development Techdegree Graduate 24,851 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

  • Lyola Rowe
    Lyola Rowe
    3,806 Points

    Please help with this challenge

    Posted on Oct 29, 2020 by Lyola Rowe
    Lyola Rowe
    3,806 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Todd Hamblen
    Todd Hamblen
    4,523 Points

    What type system is this supposed to be ran on?

    Posted on Jul 20, 2020 by Todd Hamblen
    Todd Hamblen
    4,523 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Matt Fuller
    Matt Fuller
    2,395 Points

    Is Order Count w/ Date Challenge Still Flawed?

    Posted on Jul 3, 2020 by Matt Fuller
    Matt Fuller
    2,395 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Felix Belga
    Felix Belga
    4,828 Points

    I cannot see what is wrong with my code

    Posted on May 16, 2019 by Felix Belga
    Felix Belga
    4,828 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    3 Answers

  • dfeem
    dfeem
    4,660 Points

    Looking for help on this challenge?

    Posted on Feb 17, 2019 by dfeem
    dfeem
    4,660 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

  • David Corrales
    David Corrales
    4,698 Points

    Wow, I keep getting stumped! This might not be for me! I'm trying hard though, this challenge is kicking my butt!

    Posted on Dec 17, 2018 by David Corrales
    David Corrales
    4,698 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Shain Jones
    Shain Jones
    1,315 Points

    Calculating Dates

    Posted on Oct 26, 2018 by Shain Jones
    Shain Jones
    1,315 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

  • Rose Mathurin
    Rose Mathurin
    2,882 Points

    What am i doing wrong?

    Posted on Oct 20, 2018 by Rose Mathurin
    Rose Mathurin
    2,882 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    What to do here?

    Posted on Oct 14, 2018 by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

  • Karen Shumate
    Karen Shumate
    13,579 Points

    Count the total number of orders that were ordered yesterday and have the status of 'shipped'. Alias it to ordered_yeste

    Posted on Sep 30, 2018 by Karen Shumate
    Karen Shumate
    13,579 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Courage Tafadzwa Chesa
    Courage Tafadzwa Chesa
    5,308 Points

    Does this code work lol im now stuck

    Posted on Sep 17, 2018 by Courage Tafadzwa Chesa
    Courage Tafadzwa Chesa
    5,308 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Gurdeep singh
    Gurdeep singh
    1,522 Points

    SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

    Posted on Aug 30, 2018 by Gurdeep singh
    Gurdeep singh
    1,522 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

  • Felix Bynum
    Felix Bynum
    1,129 Points

    Issues with dates, particularly "now"

    Posted on Jul 6, 2018 by Felix Bynum
    Felix Bynum
    1,129 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Ali Ahmadian
    Ali Ahmadian
    11,474 Points

    what im doing wrong?please Help!

    Posted on May 22, 2018 by Ali Ahmadian
    Ali Ahmadian
    11,474 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Stevan Lay
    Stevan Lay
    8,306 Points

    What is the correct syntax here?

    Posted on May 21, 2018 by Stevan Lay
    Stevan Lay
    8,306 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • Terri Valentine
    Terri Valentine
    23,034 Points

    SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

    Posted on May 20, 2018 by Terri Valentine
    Terri Valentine
    23,034 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    1 Answer

  • ABRAHAM NYONI
    ABRAHAM NYONI
    9,692 Points

    Can someone help me on this challenge on SQL,CALCULATING DATES.

    Posted on May 10, 2018 by ABRAHAM NYONI
    ABRAHAM NYONI
    9,692 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    8 Answers

  • Dean Wiseman
    Dean Wiseman
    20,901 Points

    Question needs to be re-worded.

    Posted on Jun 16, 2016 by Dean Wiseman
    Dean Wiseman
    20,901 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Calculating Dates

    2 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.