@vdSql:DATE_SUB not working

@vdSql:DATE_SUB(NOW(), INTERVAL 1 DAY) is not working. I tried the SQL Syntax on the table via PhpMyAdmin

SELECT * FROM `i6khs_chronoengine_chronoforms_datatable_contatto` where created > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY `created` DESC

And it worked, but when I use it with vdata it doesn't work.

What I am missing?

Thank you very much

Hi Valerio,
Hope you are doing well!

We have checked the issue in vData version 2.9.29 and it is working fine here, please let us know how have you used this @vdSql:DATE_SUB(NOW(), INTERVAL 1 DAY) in your profile of vData? Kindly share your site admin and cPanel details if possible. Please find the attachments which we have tested in our profile of vData .

Best Regards

Actually what you sent me is a different way . I was tryng to apply a filter, not to redefine a field.

How can i send you privately website credentials?

Hi,
Thanks for your reply!

Please send it to our email address vcare@wdmtech.com or create a ticket from the URL: www.wdmtech.com/support-tickets/submit-ticket and send your website credential and the issue you are facing.

Best Regards
Daniel