Date format from Select() function is weird

AppSheet AppSheet Q&A
, ,
1

I used select() to copy Date to a different column i keep getting the date pasted in the format “Tue Oct 19 2021 00:00:00 GMT+0530 (India Standard Time)”

2

Review the column to see if the Long Date Format property is “on”. If so, turn it off.

3X_9_e_9e12192b4df7db7983c929a7d54c607a85671ff7.png
3X_9_e_9e12192b4df7db7983c929a7d54c607a85671ff7.png1252×616 29.7 KB

1 Like
3

Im using enum because i needed a dropdown, so there is no long date format option available.

3X_5_7_577cfc4b619ea7a972a765cad8e87457e041dd27.jpeg
3X_5_7_577cfc4b619ea7a972a765cad8e87457e041dd27.jpeg1932×1340 108 KB

4

From your original description, it sounds like the unwanted format is appearing in your spreadsheet?

2 Likes
5

Yes!

2 Likes
6

In the spreadsheet, please explicitly set that column’s cell format to the desired data type, such as Date or Date time.

3 Likes
7

That’s the first thing I did, But i’m still getting only the long date format, both the columns in google sheets are set to date

8

There are many different kinds of Date formats available in a spreadsheet, which one are you using?