https://teamtreehouse.com/library/crud-operations-with-php/reading-and-writing-reports/working-with-dates, crud operatio

Hi there, Benoit Tordeurs ! Actually, you're not far off on this one. But part of the problem is that you're overwriting the $date variable that is sent in. Also, you're trying to use the format they gave as an example as the arguments for the date function which isn't exactly correct.

I chose to return the results directly without creating new variables as it feels cleaner and more concise to me. But this is my opinion.

function convert_date_sql($date) {
    //add your code here
    return date('Y-m-d', strtotime($date));
}

It's just one line of code but it says essentially this: "Return the date with the year first, month second and day last. Separate these with a hyphen. Parse any English version of time like "tomorrow" or "yesterday" to a UNIX timestamp."

You say that you didn't find any answers in the MDN documentation. But this is not surprising at all. MDN (Mozilla Developer Network) contains documentation about Open Web technologies such as HTML, CSS, and JavaScript. You will not find PHP documentation on MDN. Instead, you should be using the PHP documentation at php.net

To make this perfectly clear, PHP and JavaScript are two entirely different languages. Just as both English and Swedish are Germanic based languages, PHP and JavaScript are both programming languages, but they are both unique just as English and Swedish are distinct languages.

Hope this helps!