HELP! change date format!

SG752 · 03-10-2020 10:31 AM

Hello, I need help changing date displayed from DD/MM/YYYY to DD/month/YYYY

Steve

SG752

Thx but I still don’t get it could you provide a step by step guide please. I would like the app to read the date as 03-Mars-2020.

Aleksi

TEXT(TODAY(),“dd-mmmm-yyyy”) will give you 11-March-2020 and TEXT(TODAY(),“dd-mmm-yyyy”) will be 11-Mar-2020

Austin_Samagam

can the above formula be modified to display the weekday (Mon…Tue…etc) as well? End result would be Mon 11-Mar ?

Koichi_Tsuji

BIJAY_KUMAR

i have an issue in Appsheet wherein in the MapView, the address field is located but when click the navigation ( car symbol ), it redirects me to GoogleMaps which cannot locate the same column.
how it is Possible that Mapview can locate, but when the same is used for navigation, it is not locatable.
The address date has all important data like locality, City, state, country etc.
can you suggest a workaround?

Steve

Try:

TEXT(TODAY(), "ddd d-mmm")

See also:

Austin_Samagam

Thank you, this worked. TEXT is so much easier than the previous way of converting Dates/Time! Thank you for continuing to provide help and making AppSheets better and better!!

pcakhilnadh

Where to write this? I wrote this on formula then the entire columns disappears away from my forms

Alejandro_Delg1

I need some refinement…
Does it mean, that we have to create another one virtual column to display dates in format we need?

Aleksi

It depends where do you want to use it. For example with a text field and initial value.

Thibaulthess1

Hello,

I have another question somehow related to the initial topic.

Is that possible to select a date based only on 'Month' and 'Year'? Without considering the day.

So for example instead of the traditional calendar, having only the list of months per year.

How would you achieve that?

Thank you in advance.

Steve

@Thibaulthess1 wrote:

Is that possible to select a date based only on 'Month' and 'Year'? Without considering the day.

Not using a Date column type. The best you could do is a Text column type with a Valid If or Suggested values expression that generates a list of possible month-year combinations in a dropdown list.