DateAdd Too few parameters. Expected 1

[jxwd]

I wish! it's not practice as the company has many inhouse systems still using access... the only sticking issues is this one! and as the article suggests is should work... !

 

[cheekybuddha]

///////////////////////////////////////////////////////////////////////////////////
// db_query - this does global error handling... all subsiquent chould use this...
///////////////////////////////////////////////////////////////////////////////////
//
function db_query ($query, $error_message) {
  $result = odbc_exec($this->ms_access, $query);
  if (odbc_error($this->ms_access))
      die(odbc_errormsg($this->ms_access)."<br />".$query."<br />".$error_message);
  else
      return $result;
}

$sql = 'SELECT DateOfCal AS NextCal FROM TblCalibItems;';
$rs = db_query($sql, $err_msg);
while ($row = odbc_fetch_array($rs)) {
  $dt = new DateTime($row['NextCal']);
  $dt = $dt->add(new DateInterval('P3M');
  echo($dt->format('Y-m-d');
}

 

[jxwd]

It needs to be sorted by the calculated result. So I will need to run ksort / asort after this... and TblCalibItems has a lot of records...

IE SELECT DateAdd(\"m\", NoOfMonths, DateValue(DateOfCal))

NoOfMonths is an integer variable...

 

[cheekybuddha]

NoOfMonths is different for each record?

 

[jxwd]

No but, I am working toward NextCal as the sort order too IE

SELECT DateAdd(\"month\", NoOfMonths, DateOfCal) AS NextCal ORDER BY NextCal;

NoOfMonths could be 1 or 120...

 

[jxwd]

Sorry confusion with ODBC != qodbc... gotcha...

I did find this that suggested it's doable with ODBC https://bytes.com/topic/asp-classic/answers/57197-dateadd-sql-statement-not-working

 

[jxwd]

And it definitely knows DateAdd as it doesn't complain that it's not defined... feels so near but so far!

 

[GPGeorge]

qodbc != odbc

I think it's a specific driver for some accounting package

That would be QuickBooks, would it not?

 

[jxwd]

Success this ran, I think 'm' not months, or mm and with the single quotes... :

SELECT TOP 10 *,DateAdd('m',-2,now()) AS NextCal FROM TblCalibItems;

Thank you all

 

[arnelgp]

congratulazion, you succeed in this level!

 

[cheekybuddha]

Good work!