I need to find out previous months by using addMonths() function. But while doing this it is giving me error "call to member function on non-object".
Below is my Controller Code snippet:
<?php
class ModelGridController extends Controller
{
public function index()
{
$title = "Model as Stock Market Grid" ;
$latestDatetime = Salemodel::select(DB::raw('max(Datetime) as date'))->get();
$latestDate = $latestDatetime[0]->date;
$previousDatetime = Salemodel::select(DB::raw("max(CASE WHEN (Datetime < '$latestDate') THEN Datetime END) as date" ))->get();
$previousDate = $previousDatetime[0]->date;
$currentDatetime = \Carbon\Carbon::now();
$currentYear = $currentDatetime->format("Y");
$date = strtotime($latestDate);
$newformat = date('y-m-d:H:i:s',$date);
$threeMonthBefore = $date->addMonths(-3);
//$sixMonthBefore = $date->addMonths(-6);
//$twelveMonthBefore = $date->addMonths(-12);
echo $date ." ".$newformat ;
echo $latestDate ." ".$previousDate." ".$currentYear." ";
}
}
How to rectify this issue?