X-Cart forums

[minfinger]

I was looking at some thing and using the existing formulas in the main.php will only get my the previous 365 days. I want, for example from Jan 1, 2012 to Dec 31, 2012. But the existing query in the main.php and the $start_date formulas only account for a start date and do not set a range or end date. Or rather the formula does set the range, but it sets it as the $curtime.

Existing formula:

    $date_condition = "AND $sql_tbl[orders].date>='$start_date' AND $sql_tbl[orders].date<='$curtime'";

Any help?

[Johnwiggity]

I never got it to work the way I wanted to.

[minfinger]

I found another thread where a guy figured out how to do yesterday, last 7 and last 30. I'm not in the office eight now, but I'll look when I get back.

I think the best way is to have 2 types formulas working for to desperate sections. Unless I can figure out how to make the php set the end time through the code.

[minfinger]

John,

I found the thread: http://forum.x-cart.com/showthread.php?t=49889

He talks about changing/adding this code to the main.php

$start_dates[] = mktime() - 24*3600
$start_dates[] = mktime() - 7*24*3600
$start_dates[] = mktime() - 30*24*3600