In my google sheet locale format is English. I enter all dates in format dd.mm.yy - its ok.
@Sofjw722 In appsheet try a text column using this formulae:
[ClientName] & " - " & Text([DateOfBirth], "dd.mm.yy")
Same as
CONCATENATE([ClientName], " - ", Text([DateOfBirth], "dd.mm.yy"))
does not work.. writes: "TEXT function with two arguments requires a temporal type and text representing a date format"
Make sure your DateOfBirth column is set to Date type.
Dates will display in your App views according to the Locale/Regional Settings on your device/browser. Set the locale on your device to the desired settings and it will fix your display.
A part from that, to have no calculation errors, make sure both, your sheet and your table settings in the AppSheet Editor, are set to the same locale.
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |