English Month in Submit Date

Hi @woernib,

GSheetConnector just fetches the posted data submitted by CF7 and saves it to the Google Sheet.

$submission->get_posted_data()

Is your front-end date field displays date in Deutsch format?

If you just need the form submitted date then you can simply add a “date” special mail tag as a header to your Google Sheet. This will display date as per set in WordPress General Settings.

Hope this helps. Let us know.

Thanks
Abdullah

Hi @westerndeal,
Thanks for the quick reply. Yes, I created the first column in the Google Sheet as “date”, the form submission date is also transferred, but unfortunately not with the German month name, as you can see here:
https://thank-god-its-monday.org/people-first/CF7%20Google%20Sheets%20Connector%20Problem.pdf
Any ideas?

@woernib

Make sure both the field names must be different else it will override.

Just test as below.

1st change the name of the Date Field added by CF7 as “submit-date” or something that is easy for you to understand.

2nd place “date” as a header on your Google Sheet( you have already added )

Lastly, check that it saves date in your language.

let us know.

Problem still exists. But, if in Settings/General I change the date format to custom date “d.m.Y” and in Google Sheet I format the date column to custom format like “5. August 1930” the form submission date will appear as “25. Mai 2022” (as expected).

I think if CF7 Google Sheets Connector would transfer just a native date without considering the WordPress date format settings it would work much better because you can specify the date format independently in Google Sheets.

Thanks for your support, I’ll mark the topic as resolved.