Hi everyone,
I’m experiencing an issue with inconsistent date formats in one of my AppSheet apps:
• My app is based in the UK, the Google Sheet uses the UK locale, and my browser is also set to the UK region.
• A virtual column with the expression SELECT(Transactions[Date]... displays a list of dates in the correct UK format (DD/MM/YYYY) in the Expression Assistant and Form View.
• However, in the Detail View, the list of dates are displayed to US format (MM/DD/YYYY) after saving the record.
(For context, what I'm trying to do is get a list of dates that the customer has existing related charges and deduct them from a list of dates that we need to charge them and then with a repeat loop we'll charge them for the remaining dates. But so far it cannot deduct the existing transactions as the dates are not matched so the action that calls the loop just freezes the whole app as there's no way for it to determine when to stop repeating.)
What I’ve Tried:
• Verified table and app locale settings (set to “United Kingdom”).
• Checked the connected Google Sheet—dates are stored in UK format.
This issue only occurs in the Detail View, and all my other apps using the same setup work fine.:
1. Has anyone else encountered this issue?
2. Could this be a rendering bug in Detail View? It's the same issue across different devices and browsers, and different users using this same app.
3. Are there additional settings I should check?
Thanks for your help!
LinkedIn
Twitter
