I have a strange error, A have a computed Ke...

[Jake_Brown]

I have a strange error,

A have a computed Key based on 3 pieces of information the customer name, appt date and quote number. Now only for this specific row has it decided to take the Appt Date as a US format. 1. the spreadsheet settings are Australian

2. the App data Tables localize settings are australian 3. the row is definitely in the Spreadsheet.

How do i get around this for now until fixed?

[Aleksi_Alkio]

Convert the date as a string like… CONCATENATE(DAY([Date]),"/",MONTH([Date]),"/",YEAR([Date]))