wpDataTables has several options of Date format in the Settings.

But none of them is: 'd/m/y'
For example: 31/05/23 (d/m/y)

- How can I be able to set the Date format ('d/m/y') in the Settings?

I am currently using this Workaround Code.
But with a higher processing cost due to the function requires scanning all column(s) lines.

I look forward to an answer.

Regards,

<?php
/**
 * Filter and format the cell value by column name.
 *
 * @param string $formattedValue The cell value.
 * @param int    $tableId       The ID of the table.
 * @param string $columnHeader  The name of the column.
 *
 * @return string The formatted cell value.
 */
function wpdatatables_filter_cell_by_column_name($formattedValue, $tableId , $columnHeader) { 
    // If the column name does not contain the string 'date', return the original value.
    if (strpos($columnHeader, 'date') === false) { 
        return $formattedValue;
    } 
    // If the column name contains 'date', format the cell value.
    $date = DateTime::createFromFormat('d/m/Y', $formattedValue);
    // If the value is not a valid date, return the original value.
    if ($date === false) {
        return $formattedValue;
    }
    // If the value is a valid date, return it in the 'd/m/y' format.
    return $date->format('d/m/y');
}
add_filter('wpdatatables_filter_cell_output', 'wpdatatables_filter_cell_by_column_name', 10, 3);

I thought it would be simpler. It is hardly simpler.

And as a non-expert in coding, besides strongly hope for this to happen, I can share this 'budget-friendly' workaround:

(Any suggestions to improve are welcome)

<?php
/**
 * Filter and format the cell value by column name.
 *
 * @param string $formattedValue The cell value.
 * @param int    $tableId       The ID of the table.
 * @param string $columnHeader  The name of the column.
 *
 * @return string The formatted cell value.
 */
function wpdatatables_filter_cell_by_column_name($formattedValue, $tableId , $columnHeader) { 
    // If the column name does not contain the string 'date', return the original value.
    if (strpos($columnHeader, 'date') === false) { 
        return $formattedValue;
    } 
    // If the column name contains 'date', format the cell value.
    $date = DateTime::createFromFormat('d/m/y', $formattedValue);
    // If the value is not a valid date, return the original value.
    if ($date === false) {
        return $formattedValue;
    }
    // If the value is a valid date, return it in the 'd/m/y' format.
    return $date->format('d/m/y');
}
add_filter('wpdatatables_filter_cell_output', 'wpdatatables_filter_cell_by_column_name', 10, 3);

Thanks for the explanation.

I shall take double caution.

Of course, I'll keep venturing into trying  improve the workaround too.

But aware that it is a paleactive solution.
I mean, until the devs add this new Date Format.

I think it would be a great (apparently) 'not-so-hard-effort' item to add to the next update changelog.
('casually mentioning' to Product Manager)

Just a suggestion from someone who greatly appreciates the work of wpDataTable's team.

Best Regards,