Re: Question formatting mm/dd/yyyy to dd/mm/yyyy

Dev_TI · 08-16-2019 06:09 AM

I have two applications that need to record a date in dd / mm / yyyy format that have the same setting, but the first one writes in mm / dd / yyyy format and the other dd / mm / yyyy. How can I solve this

LeventK

@Dev_TI
Ensure that you have checked and verifed both the date formatting in your spreadsheet and the locale setting in your app tables. Also ensure that both devices have the same locale setting.

Dev_TI

Yes I checked and the settings are the same.

Dev_TI

Log system
Properties:
{
“IfModifiedSinceDate”: “2019-08-16T12:35:27.9210721Z”,
“settings”: “{”_RowNumber":“0”,"_EMAIL":"","_NAME":"","_LOCATION":"",“Options Heading”:"",“Option 1”:"",“Option 2”:"",“Country Option”:"",“Language Option”:"",“Option 5”:"",“Option 6”:"",“Option 7”:"",“Option 8”:"",“Option 9”:"","_THISUSER":“onlyvalue”}",
“getAllTables”: “True”,
“checkLocation”: “True”,
“isPreview”: “False”,
“apiLevel”: “2”,
“tzOffset”: “180”,
“locale”: “pt-BR”,
“tableTimestamps”: “{\r\n “_Per User Settings”: “2019-08-23T10:55:23.4138952Z”,\r\n “Equipe”: “2019-08-23T10:55:23.4240958Z”,\r\n “Menu”: “2019-08-23T10:55:26.1040986Z”,\r\n “Pedidos”: null,\r\n “Médicos”: “2019-08-23T10:55:24.9840192Z”,\r\n “Meta Total”: “2019-08-23T10:55:25.9690885Z”\r\n}”,
“lastSyncTime”: “8/23/2019 10:55:29 AM”,
“appStartTime”: “8/22/2019 6:58:29 PM”,
“dataStamp”: “8/23/2019 11:20:50 AM”,
“clientId”: “2b2a7ed5-a77a-493c-b526-bf19a4cd0e05”,
“build”: “3ddc7873c32d5244aea2-1566432144323-49fdf9d952”,
“hasValidPlan”: “True”,
“localVersion”: “1.000073”,
“AppTemplateName”: “7cc733ab-32aa-4b0b-88ff-4be2cb52eadc”,
“Operation”: “App sync”,
“RecordType”: “Stop”,
“AppTemplateVersion”: “1.000073”,
“AppDefinitionChanged”: true,
“Table:Meta Total”: “LastModified:8/23/2019 11:22:48 AM, NotModified:False”,
“Table:Menu”: “LastModified:8/23/2019 11:22:47 AM, NotModified:False”,
“Table:Equipe”: “LastModified:8/23/2019 11:22:44 AM, NotModified:False”,
“Table:Médicos”: “LastModified:8/23/2019 11:22:46 AM, NotModified:False”,
“Table:Pedidos”: “LastModified:8/23/2019 11:22:44 AM, NotModified:False”,
“Table:_Per User Settings”: “LastModified:8/23/2019 11:22:44 AM, NotModified:False”,
“Performance”: “{“Version”:1,“Time”:“00:00:06.5038420”,“PerformanceTimingRoot”:{“Mid”:130,“Timer”:{“Time”:“00:00:06.5038420”},“Children”:[{“Mid”:63,“Timer”:{“Time”:“00:00:06.5038386”},“Children”:[{“Mid”:62,“Timer”:{“Time”:“00:00:00.2370279”}},{“Mid”:244,“Timer”:{“Time”:“00:00:00.0528566”}},{“Mid”:155,“Timer”:{“Time”:“00:00:00.3952149”}},{“Mid”:117,“Params”:{“ParamList”:[{“Pid”:5,“Value”:“2”}]},“Timer”:{“Time”:“00:00:05.8186810”},“Children”:[{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Pedidos”},{“Pid”:21,“Value”:“11.22.44.173636”}]},“Timer”:{“Time”:“00:00:02.5976894”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.5675627”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Pedidos”}]},“Timer”:{“Time”:“00:00:02.5675509”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“1772”}]},“Timer”:{“Time”:“00:00:02.5543323”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.4143413”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:01.5933018”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:01.5932627”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.8204419”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.5134677”}},{“Mid”:239,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“1772”},{“Pid”:3,“Value”:“76”}]},“Timer”:{“Time”:“00:00:00.3066719”}}]}]},{“Mid”:15,“Timer”:{“Time”:“00:00:00.1399658”}}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Pedidos 2_Schema”}]},“Timer”:{“Time”:“00:00:00.0109475”},“Children”:[{“Mid”:218,“Timer”:{“Time”:“00:00:00.0108861”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Equipe”},{“Pid”:21,“Value”:“11.22.44.173636”}]},“Timer”:{“Time”:“00:00:03.2124965”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:03.2124195”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Equipe”}]},“Timer”:{“Time”:“00:00:03.2124121”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“23”}]},“Timer”:{“Time”:“00:00:03.2110073”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:03.2105513”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:02.1359779”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:02.1359295”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:01.0745423”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:01.0744085”}}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Médicos”},{“Pid”:21,“Value”:“11.22.46.773835”}]},“Timer”:{“Time”:“00:00:01.3309471”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:01.3292648”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Médicos”}]},“Timer”:{“Time”:“00:00:01.3292513”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“273”}]},“Timer”:{“Time”:“00:00:01.2173495”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:01.2146154”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.9881703”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.9881200”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.2263823”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.2234351”}}]}]}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Médicos 2_Schema”}]},“Timer”:{“Time”:“00:00:00.1116173”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:00.1115823”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Pedidos”}]},“Timer”:{“Time”:“00:00:00.1115797”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Pedidos”}]},“Timer”:{“Time”:“00:00:00.1115735”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.1115559”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.0451471”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Pedidos”}]},“Timer”:{“Time”:“00:00:00.0451403”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“1772”}]},“Timer”:{“Time”:“00:00:00.0443032”},“Children”:}]}]}]}]}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Meta Total”},{“Pid”:21,“Value”:“11.22.48.103934”}]},“Timer”:{“Time”:“00:00:01.0091945”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:01.0091748”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Meta Total”}]},“Timer”:{“Time”:“00:00:01.0091669”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“1”}]},“Timer”:{“Time”:“00:00:01.0090460”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:01.0087116”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.8173194”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.8172803”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.1913649”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.1913177”}}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Menu”},{“Pid”:21,“Value”:“11.22.47.388879”}]},“Timer”:{“Time”:“00:00:02.6044715”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.6043972”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Menu”}]},“Timer”:{“Time”:“00:00:02.6043879”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“29”}]},“Timer”:{“Time”:“00:00:02.6042926”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.6039924”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:01.8991487”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:01.8991060”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.7048116”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.7047287”}}]}]}]}]}]}]}]}]}]},“IsEmpty”:false}”,
“Result”: “Success”
}

Dev_TI

Yes I checked and the settings are the same.