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

(Jake Brown) #1

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

  1. 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) #2

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