If condition error for different data form

[Denis_Dal_Soler]

Hey, I have a "data" field in my sheet with this format "DD/MM/YY  HH.MM.SS". Unfortunately this field in my app appears as "DD/MM/YY  HH:MM:SS". For this reason a if condition that I inserted in a column doesn't work well. How can I do please? Thanks

[jyothis_m · Accepted solution]

You can add a virtual column with formula

TEXT([DateTime],"DD/MM/YY  HH.MM.SS") if you want to display dat time as per your format. 

If were trying to do something else pls explain a bit more.

[Steve]

Dates and times are displayed in the app according to the locale settings of the device.

The display format of values in the spreadsheet have no effect on the appearance of the values in the app.