how to format date as dd.mm.yyyy

Joachim Mund

Hi all,

smartsheet date format functionality only has the format "dd.mm.yy" but how can I format as "dd.mm.yyyy"?

Greetings, Joachim

Bassam Khalil

Hi @Joachim Mund 

Hope you are fine, you can do that from the Account/Personal Settings/Settings tab then change the regional reference, please check the following screenshot

Joachim Mund

Hi @Bassam.M Khalil

thank you, but it is e.g. "15.04.21" and not "15.04.2021":

Bassam Khalil

Hi @Joachim Mund

You are using Deutsch date format (dd.mm.yy) if you want to change to (dd.mm.yyyy ) you need to select a different regional setting like what i show you as an example ( English Malta ). try it and you will see in all of your sheets, reports, update request the change.