I think I may have worked it out.
I have a column titled Start Date and this is displayed e.g. 8th April 2018.
In the app I have created a virtual column and concatenated the Start Date column with a second virtual column (with formula =SWITCH(WEEKDAY([Start Date]),1,“Sun”, 2,“Mon”,3,“Tue”,4,“Wed”,5,“Thu”,6,“Fri”,“Sat”)) and the field type set to text expeciting it to display as Sunday 8th April 2018 but it shows as Sunday 04/08/2018.
Is there a way around this to get it displayed as I want?
- Your account id: 521238 2. The app name: Arriva Duties 3. The table name: Rostas 4. The field name: Day/Date (the concatenated virtual column) 5. The exact steps to reproduce: I use a form to enter the data and sync the app.