This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Australia Date Format Not Working

Posted on 08-10-2019 03:37 PM
adambc
New Member
Reply posted on --/--/---- --:-- AM

Hello,
I have followed the instructions that are meant to update dates into Australia format from here:

But this is not working. Is there something I am missing?

Details:

Set the locale in the google sheets:

2X_c_c2631b15331e319c16185bdc8d9be399fe94169e.png

Manually update the format of all date columns in the google sheet by going format _> number -> date/time
2X_7_7e6f264877dc700b7a46cbdb907c4d247ab99629.png

Verified the data loclate is coming through correctly in Apphseet:

2X_4_40dec19f7abe6e98dfa61e8a8525c063e60cb1e5.png

Updated google chrome browser language settings:

2X_c_c38baaa34474baf47c6cba826dc2783726bc20e5.png

Dates are still appearing in the incorrect format:
2X_3_3f20d472ab00b943e94328317809d8967e8ee161.png

0 0 413
Topic Labels
0 Likes
0 REPLIES 0
Top Labels in this Space