Change Date format

AppSheet AppSheet Q&A
1

Hello Community Team,

I need your help with changing the date format from (mm/dd/yyyy) to (dd/mm/yyyy).

2

Locale settings should take care of Date and Numeric formats for you automatically.

If that doesn’t apply for your app, then you can use the TEXT() function with a Date format string. Click the link for more details and implementation examples.

3

It,'s not working

1 Like
4

Please show what you have tried.

5

Actually, I’m confused how to go?

6

@RSHARM01

TEXT([YourDateColumn], “dd/mm/yyyy”)

7

Incase if it is action

([ORDER DATE],"dd/mm/yyyy ")

(Today(), "dd/mm/yyyy ")

If this didn’t work. Please share the table screenshot

8

Hii @jaichith

I tried your formula but still it’s not working

RSHARM01_0-1695401453528.png
RSHARM01_0-1695401453528.png1583Ă—186 17.7 KB

9

I think @jaichith might have shortcut things. His suggested items are to be used with the TEXT() function.

**TEXT**(Today(), "dd/mm/yyyy")
10

I think still it’s not working the date should take automatically

RSHARM01_0-1695438047237.png
RSHARM01_0-1695438047237.png1557Ă—208 16.9 KB

11

TEXT() returns a text string which is not a Date type.

I am not sure if you can manipulate the format of a Date column other than tweaking your device locale.

https://support.google.com/appsheet/answer/10106702?sjid=13588342874908908651-AP

12

"

Date, Time, and DateTime formats in apps

Date, Time, and DateTime formats are displayed in AppSheet apps based on:

  1. Your mobile device’s locale when running your app on a mobile device.
  2. Your browser’s language setting when running your app in a browser."

https://support.google.com/appsheet/answer/10106702?hl=en

If you are using chrome go to chrome://settings/languages and make UK as your #1 language

13

Screenshot_2023-09-23-10-55-29-16_40deb401b9ffe8e1df2f1cc5ba480b12.jpg
Screenshot_2023-09-23-10-55-29-16_40deb401b9ffe8e1df2f1cc5ba480b12.jpg1080Ă—2400 142 KB

It works for me !!!

1 Like
14

For more reference:

https://support.google.com/appsheet/answer/10107701?hl=en

Please check for Gsheet , Table locale. This can inhibit your results.

15

Hello there!

I wanted to bring to your attention that when I fill out the form, the date format appears correct. However, when I receive the email, the format of the date changes and the data source also aappears to be different like email. For your reference, I have attached an image.

RSHARM01_1-1695619439459.png
RSHARM01_1-1695619439459.png591Ă—176 3.15 KB

RSHARM01_0-1695619402244.png
RSHARM01_0-1695619402244.png385Ă—101 3.21 KB

16

As mentioned by @WillowMobileSys please put TEXT(Today(), “dd/mm/yyyy”) in your email body/email template

17

Now I am getting this error

RSHARM01_0-1695621370757.png
RSHARM01_0-1695621370757.png523Ă—180 3.61 KB

RSHARM01_0-1695621291182.png
RSHARM01_0-1695621291182.png903Ă—542 46.4 KB

18

Hello everyone,

After changing the DATA locale from USA to IND, the issue was resolved. Also, note that you don’t need to change any formula from today().

RSHARM01_1-1695635085654.png

RSHARM01_2-1695635095970.png

RSHARM01_0-1695634945038.png
RSHARM01_0-1695634945038.png1094Ă—537 26.5 KB

1 Like
19

For long time we were insisting this For changing locale.

1 Like
20

Please note that this was suggested in very first response to your post. Maybe it wasn’t clear what this meant? If so, simply ask,we are all here to help. The important thing is that you got to the easy solution in the end.

Even though you resolved your initial problem, your error is another learning opportunity.

The issue causing the error is that you placed the function INSIDE of column name delimiters in the template.

The initial problem expression:

<<**[**TEXT(Today(), "dd/mm/yyyy")**]**>>

Square brackets, “”, are used to designate column names and are not required in this expression. The correct syntax, in a template, is:

<<TEXT(Today(), "dd/mm/yyyy")>>
2 Likes