Date column. I have column with data type, a...

(tsuji koichi) #1

Date column.

I have column with data type, and both table and spreadsheet locale is set as UK, ie. the data format is to be Date/Month/Year. When I enter date to this column through the app, app picks up the date in the correct format.

At the same time, i use this date column for another column. This column have app formula like this.

[Inspection ID]&" -

"&[Date]

However, this returns the text : Inspection ID -

Month/Date/Year

Obviously the app formula is returning US date type.

Any idea, how can we fix this problem so that we correctly pick up the date format in app formula?

(Aleksi Alkio) #2

[Inspection ID]&" -

"&TEXT([Date])

(tsuji koichi) #3

@Aleksi_Alkio Hi, texted by adding text function, but unfortunately the result was the same…

(Aleksi Alkio) #4

I tried the above formula and for me it was working correctly. If the TEXT expression is missing, it will use US format.

Of course you can always create your expression like =CONCATENATE([Inspection],"-

“,DAY([DATE]),”/",MONTH([DATE]),"/",YEAR([DATE]))

(Simon Blackburn) #5

I had the same problem with my date and I used the advice from @Aleksi_Alkio and its worked a dream.

(tsuji koichi) #6

@Aleksi_Alkio @Simon_Blackburn Thank you both. Yes, I took advice from Aleksi and put expression in that way, now pulling the

texts what I need. Once again, thank you very much!