Hello All,

I am using Excel with a OBDC connection. I want to only pull data from a table from the past 30 days. I believe the below code should work, but it does not return any data. Any help would be greatly appreciated.

SELECT paymentdate, paymentmonth, paymentyear, portfolio, paymentstatus, assignedto, paymentamount FROM `collectionsmax`.`payments` WHERE 'paymentdate' BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();
Thanks,

Lonney