Michael Simpson

Thanks.

You can change data by purchasing the CFDB Editor or directly in PHPMyAdmin

In the CFDB Options for CF7, there is an option to capture the form page URL that you can turn on. You can use that in a filter.

Are you trying to do this when a submission comes in or afterward?

http://cfdbplugin.com/?page_id=804

The plugin is storing the date string in the format that the browser sends (which could be different than it displays it). The plugin just displays what it has verbatim.

You can try to (1) convert it when it goes into the DB or (2) try to convert it when you display it in a shortcode or export.

(1) You will need to hook in the following PHP code to do the conversion. See: http://cfdbplugin.com/?page_id=747

function convert_date_filter($formData) {
    $formName = 'dateform'; // change this to your form's name
    if ($formData && $formName == $formData->title) {
        // change 'field' to the name of the field holding your date
        $formData->posted_data['field'] =
                date('d/m/y',
                        strtotime($formData->posted_data['field']));
    }
    return $formData;
}
add_filter('cfdb_form_data', 'convert_date_filter');

(2) In a shortcode or export, assuming your date field was called “field”, you can use a transform like this:
trans="field=strtotime(field)&&field=date(d/m/y,field)"

• This reply was modified 9 years, 7 months ago by Michael Simpson.

No. But you can create an export link in the plugin and use that in something else to automate calling it.

The plugin doesn’t save it. You can either save the URL yourself on a page
or put the equivalent [cfdb-export-link] shortcode on a page. You can also make that page private.