Week/Date Question

Dan should I use that in a cfset statement or is that used in the sql?

Sorry to sound like such a noob, but I always have problems when it comes to dates. My database (MySql) is picky and I didn't set it up so I can't change it.

Charles, normally I would do something like that. However I am going to be using it as an included stat that I want to automatically update and give the recordcount.

There is a few different things you can do depending what you want to achieve.

If you want the orders from the last week run a query like this:

.....where order_date > #dateadd("ww", -1, now())#

A more powerful way would be to offer the user to select the start and end date for the query, then run something like:

...where order_date between #form.start_date# and #form.end_date#

Assuming your week starts on Sunday.

StartDate = createdate(year(now()), month(now()), day(now());
while (DayofWeekAsString(StartDate) is not "Sunday") {
StartDate = dateadd("d" -1, StartDate);
}

That should get you started.