Hi Saro

Thank you for reaching out to us.

All database entries are usually in UTC+0

wpDataTables has issues with Formidable Forms based tables and Gravity Forms based tables, for instance. They save the entry time in UTC+0, and wpDataTables sees it just like that since it's pulling raw data from the database. It doesn't have any adapters which would recognize the current date and time.

If someone need such function can grab some code:

function timestamp_for_wpdatatables ( $formdata, $tableId ) {   

    $columnsData = WDTConfigController::loadColumnsFromDB($tableId);      foreach ($columnsData as $column) {          if ($column->orig_header == "timestamp") {                  $formdata["timestamp"] = date("Y-m-d H:i:s");          }elseif ($column->orig_header == "created" && get_query_var('new_created_for_wpdatatables') == true) {                 $formdata["created"] = date("Y-m-d H:i:s");          }

     }         return $formdata; } add_filter('wpdatatables_filter_formdata_before_save', 'timestamp_for_wpdatatables',10,2);

function created_for_wpdatatables ( $formdata, $tableId ) {

    if ($formdata['wdt_ID'] == '') {         set_query_var('new_created_for_wpdatatables', true);     }     return $formdata; } add_filter('wpdatatables_filter_frontend_formdata', 'created_for_wpdatatables',10,2);

This can auto-increment datetime into columns with headers "timestamp" or "created"

Please note that this is a custom solution, so you will need some coding knowledge to implement this. Included support for the plugin doesn't cover writing custom code.

Hello Saro

I'm sorry for the misinformation provided here, but what Blazenka shared with you is for manual, editable tables which have a DateTime column that gets updated every time a user edits the data. It is used for entering the exact time and date of when the new data is being entered. It has nothing to do with Gravity Forms-based tables.

I believe the issue is with the database, similar to the other ticket you have open with me. I talked to one of our developers, and he asked if it's possible for you to clone your website?

If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.

The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.

Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.

Also, please note that this is a public ticket, so make sure to enable the PRIVATE response, so your duplicator files are only visible to us.

Hello again Saro

Our developers believe that this is happening because you set the "date" type column for DateTime values. However, we can't fully replicate the issue locally without a more detailed explanation of what you created, on wich URLs are charts and tables, where you set the 0 (is it in Gravity), etc?

The quickest way to get to the bottom of this would be with a duplicated site, but if you're not willing to provide us with that, please provide us with a detailed explanation how we can replicate it locally, and we'll see what we can do.

Thank you for the info, Saro, I forwarded it to our developers, and they said they would still need the duplicated site so they can troubleshoot and debug this locally.

If you have some confidential information, could you create a staging site without the sensitive data, replicate the issue, and then duplicate that site and send it to us in a Private response?

Hi again Saro.

If you're using a DateTime column, you need to use the DateTime filter.

Sunce you set predefined filtering in Gravity settings, filtering of the last day ("Filter by last X time period" set to "1 day"), it will always be displayed like that because this filter will always be within this logic and it can't display what you need after the load.

You're welcome, Saro

The URL filters are basically values that are applied to the actual filters of wpDataTables, and the only valid date and dateTime filters in wpDataTables are range-type filters, so there's no way to apply only today's entries through them.