(04-01-2011, 07:43 PM)lpalacin Wrote: Sorry:
When I put a date in a search form it says me: "Invalid start date for creation date range"
My browser is firefox in spanish version.
Can anybody help me?
Thank

(04-05-2011, 02:00 AM)lpalacin Wrote: Thanks. For now, I have designed a solution:
It works with mktime
Needed. in the final search.
It works.


In Inc.ClassDMS.php


$searchCreateDate = "";


if ($creationstartdate) {
///if ($createstartdate) {
///$startdate = makeTimeStamp(0, 0, 0, $createstartdate["year"], $createstartdate["month"], $createstartdate["day"]);
///$startdate = makeTimeStamp(0, 0, 0, $createstartdate["month"], $createstartdate["day"], $createstartdate["year"]);
$startdate = mktime (0,0,0, $creationstartdate["month"], $creationstartdate["day"], $creationstartdate["year"]);
///$startdate = mktime (0,0,0, $createstartdate["month"], $createstartdate["day"], $createstartdate["year"]);

if ($startdate) {
$searchCreateDate .= "`tblDocuments`.`date` >= ".$startdate;
}
}

if ($creationenddate) {
///if ($createstopdate) {
///$stopdate = makeTimeStamp (23, 59, 59, $createenddate["year"], $createenddate["month"], $createenddate["day"]);
$stopdate = mktime (23, 59, 59, $creationenddate["month"], $creationenddate["day"], $creationenddate["year"]);

if ($stopdate) {
if($startdate)
$searchCreateDate .= " AND ";
$searchCreateDate .= "`tblDocuments`.`date` <= ".$stopdate;
}
}