Date Format for field to look like dd/mm/yyyy

[yaaryvp]

Hello all,

my date fields are dd.mm.yyyy and i want them to look like dd/mm/yyyy, at least when importing to excel.
How do I use the Format Pattern:

Format: Date/Time
Date/Time Format: Date
Format Pattern: ??????

Thank you

[mobhar]

You may adjust from Tools -> Locale Settings -> then search your language, and from the date directive, enter:

dd/MM/yyyy

after that, re-generate ALL the script files, and try again.

[yaaryvp]

Thank you, this worked.

Out of curiosity, how is Format Pattern used?

[mobhar]

If you want to override that global Locale Setting.

[mobhar]

You may refer to the Fields setup -> View Tag -> Format pattern