ถ้าต้องการให้ แสดงข้อมูลเรียงตามวันที่ด้วย ต้องเพิ่ม code ยังไงบ้างครับ

<?php
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("project");
mysql_query("SET character_set_results=tis620");
mysql_query("SET character_set_client=tis620");
mysql_query("SET character_set_connection=tis620");
$strSQL = "SELECT * FROM products ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);

$Per_Page = 6;   // Per Page

$Page = isset($_GET['Page']) ? $_GET['Page'] : 1;


$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
	$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
	$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
	$Num_Pages =($Num_Rows/$Per_Page)+1;
	$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" ORDER BY datepost DESC LIMIT $Page_Start , $Per_Page";
$objQuery  = mysql_query($strSQL);
?>

order by concat( right( dte, 4), left( right(dte, 7), 2), left( right( dte, 10), 2), left(dte,8))