Australian (Non-US) Date Format in Formulas and Primary Field

Hello,

I have set my profile local to Australia so the date format is DD/MM/YYYY.

This format is showing as expected for the date and date range fields.

But when I use these fields in a formula (including the auto generated primary field), the date format reverts to US format (MM/DD/YYYY).

Is there a way to set my preferred date format in formulas or the primary field?

As the only date format options I can see are compact, standard and long and not the usual DD/MMM/YYYY format options in other apps.

Thanks

Best reply by Ben Mackley

Is this mostly for display purposes? With a little work you could use the Day(), Month(), and Year() methods in the formula to extract the values you need and then use Concat() to format the data in the way that you want it.

View original
2 replies