Hi
I have the below line
$accounts = $accountsBean->get_full_list('', "accounts.date_entered > SUBDATE(NOW(),2)");
It should return data of date 10-09-2016 but it is not returning
There are 2 records of this date
Thanks
Hi
I have the below line
$accounts = $accountsBean->get_full_list('', "accounts.date_entered > SUBDATE(NOW(),2)");
It should return data of date 10-09-2016 but it is not returning
There are 2 records of this date
Thanks
Hi Jagjit Singh,
$accounts = $accountsBean->get_full_list('', "accounts.date_entered > SUBDATE(NOW(),2)");
It should return data of date 10-09-2016 but it is not returning
There are 2 records of this date
Including date & time issue.
You are seeking 10-9-2016 record but now() return data & time if it's return 10-9-2016 12:10:12 after that date & time greater than record display.
You can use DATE_FORMAT for particular date record display.
Dipesh
Hi Jagjit Singh,
$accounts = $accountsBean->get_full_list('', "accounts.date_entered > SUBDATE(NOW(),2)");
It should return data of date 10-09-2016 but it is not returning
There are 2 records of this date
Including date & time issue.
You are seeking 10-9-2016 record but now() return data & time if it's return 10-9-2016 12:10:12 after that date & time greater than record display.
You can use DATE_FORMAT for particular date record display.
Dipesh
Hi
Can u pls help me how to use date_format.
Thanks