Page 1 of 1
Date Format for field to look like dd/mm/yyyy
Posted: Tue Jul 09, 2024 5:35 pm
by 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
Re: Date Format for field to look like dd/mm/yyyy
Posted: Tue Jul 09, 2024 6:22 pm
by 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.
Re: Date Format for field to look like dd/mm/yyyy
Posted: Tue Jul 09, 2024 7:37 pm
by yaaryvp
Thank you, this worked.
Out of curiosity, how is Format Pattern used?
Re: Date Format for field to look like dd/mm/yyyy
Posted: Tue Jul 09, 2024 8:49 pm
by mobhar
If you want to override that global Locale Setting.
Re: Date Format for field to look like dd/mm/yyyy
Posted: Tue Jul 09, 2024 8:52 pm
by mobhar
You may refer to the Fields setup -> View Tag -> Format pattern