Treehouse | Community | Calculating Dates

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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 January 26, 2023 6:57am by Brian Taylor

Brian Taylor
3,436 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Help With Reporting WITH SQL

Posted September 30, 2022 2:26pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Katie Martens
1,962 Points
Counting orders from yesterday from an ecommerce database

Posted May 9, 2022 8:05pm by Katie Martens

Katie Martens
1,962 Points
3 Answers
Alessandro Pappacena
2,589 Points
Wrong count calculation

Posted May 23, 2021 10:31pm by Alessandro Pappacena

Alessandro Pappacena
2,589 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,851 Points
I am getting the answer expected the count to be 14....

Posted October 30, 2020 6:49pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,851 Points
2 Answers
Lyola Rowe
3,806 Points
Please help with this challenge

Posted October 29, 2020 5:27am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
Todd Hamblen
4,523 Points
What type system is this supposed to be ran on?

Posted July 20, 2020 4:36pm by Todd Hamblen

Todd Hamblen
4,523 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
1 Answer
Felix Belga
4,828 Points
I cannot see what is wrong with my code

Posted May 16, 2019 6:55pm by Felix Belga

Felix Belga
4,828 Points
3 Answers
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
4,660 Points
2 Answers
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 December 17, 2018 12:51am by David Corrales

David Corrales
4,698 Points
1 Answer
Shain Jones
1,315 Points
Calculating Dates

Posted October 26, 2018 6:10pm by Shain Jones

Shain Jones
1,315 Points
2 Answers
Rose Mathurin
2,882 Points
What am i doing wrong?

Posted October 20, 2018 8:02am by Rose Mathurin

Rose Mathurin
2,882 Points
1 Answer
Fairooz Adams
2,704 Points
What to do here?

Posted October 14, 2018 8:07pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
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 September 30, 2018 8:21pm by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Courage Tafadzwa Chesa
5,308 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
5,308 Points
1 Answer
Gurdeep singh
1,522 Points
SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

Posted August 30, 2018 3:29am by Gurdeep singh

Gurdeep singh
1,522 Points
2 Answers
Felix Bynum
1,129 Points
Issues with dates, particularly "now"

Posted July 6, 2018 6:53pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
Ali Ahmadian
11,474 Points
what im doing wrong?please Help!

Posted May 22, 2018 8:56pm by Ali Ahmadian

Ali Ahmadian
11,474 Points
1 Answer
Stevan Lay
8,306 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,306 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer
ABRAHAM NYONI
9,692 Points
Can someone help me on this challenge on SQL,CALCULATING DATES.

Posted May 10, 2018 10:03am by ABRAHAM NYONI

ABRAHAM NYONI
9,692 Points
8 Answers
Dean Wiseman
20,901 Points
Question needs to be re-worded.

Posted June 16, 2016 8:50pm by Dean Wiseman

Dean Wiseman
20,901 Points
2 Answers

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