I am familiar with text format. Just trying to understand all the factors influencing date format natively in the app on a particular device.
To summarize my question.
I have a different date format when entering a date in a form (MM/DD/YYYY). However afterwards this date reflects as DD/MM/YYYY in other views (eg: table view, detail view etc)
I understand that the device locale has an influence on date format.
I am however trying to understand why there would be 2 date formats within the same app on the same device.
It seems that the device locale alone is not the only determining factor, otherwise the formats should be the same across different views within that device.
So the question is what other factors influence native data format if I am using the default date column type settings (i.e. Short date and not long date) and also not using a text expression to modify it.
The other articles I referred to on my intitial question referenced that the sheet format or locale also determine date format. This however seemed to specifically reference a Google sheet and did not say much about and office 365 excel sheet.
In my app the date format on my excel sheet was manually changed to dd/mm/yyyy.
So it almost makes me think that the device locale influences the format of the form but the date format used in the sheet influences how that date format is reflected after saving the date in the form / excel sheet (i.e. table and or detail view etc).
Just trying to figure out what influences what.
Hope my question is clear now.