Autogallery SQL order by date and weight?

[MonkeyG]

Im trying to gte a handle on my template scripts.

I want to display sections with today, yesterday and 2 days ago.

This is my current template

<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY pictures
AMOUNT 30
PAGEDUPES False
GETNEW True
ORDER Weight DESC
REORDER Weight DESC
HTML Thumb

INSERT
{
LOCATION +1
HTML </tr><tr>
}
%>

Is the following correct for today and yesterdays section, for galleries sorted by date and weight??

<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY pictures
AMOUNT 30
PAGEDUPES False
GETNEW False
ORDER Display_Date 2006-09-17, Weight DESC
REORDER Display_Date 2006-09-17, Weight DESC
HTML Thumb

INSERT
{
LOCATION +1
HTML </tr><tr>
}
%>

<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY pictures
AMOUNT 30
PAGEDUPES False
GETNEW False
ORDER Display_Date 2006-09-16, Weight DESC
REORDER Display_Date 2006-09-16, Weight DESC
HTML Thumb

INSERT
{
LOCATION +1
HTML </tr><tr>
}
%>

Sorry, im just unsure about how to get the ORDER to work with two functions.

Thanks for your help!

[MonkeyG]

fiddled around and the wonders of trial and error...

This probably not the most elegant solution but it works... here it is for anyone searching gfy for a solution in the future.

<%GALLERIES
AMOUNT 25
WHERE Category='pictures' AND Approve_Date = '2006-09-16'
REWHERE Category='pictures' AND Approve_Date = '2006-09-16'
ORDER Weight DESC
REORDER Weight DESC
HTML Thumb

INSERT
{
LOCATION +1
HTML </tr><tr>
}
%>

[fusionx]

Look at the AGE, MAXAGE and MINAGE directives