How to Change Date Format from "3 Aug 2020" to "03.08.2020" in Google Data Studio?

Question

I'm using Google Data Studio with Google Sheets as a Data Source. In the Data Source, I have a Date column (German regional settings: 03.08.2020). But the Google Data Studio table displays the value as 3 Aug 2020 (so it does interpret it as a date, but the format is wrong). I found no setting to change that, I've also tried using a calculated field with TODATE function, but I don't know the syntax to convert Aug to 08 (Aug without a dot). And all the rows without a value set, display "null" (as text). Is this a bug?

EDIT: this is what it looks like after I've converted the source field to Text (setting data type to date or to text renders the same output in Google Data Studio):

Answer 1

The FORMAT_DATETIME function can be used to change the Date Format from the default (varies based on Google Account language settings) Aug 3, 2020 to 03.08.2020 (where Date represents the name of the current Date field):

0) Type: Date

At the Data Source set the Semantic Type of the current Date field back to Date

1) FORMAT_DATETIME

FORMAT_DATETIME("%d.%m.%Y", Date)

Google Data Studio Report and a GIF to elaborate: