Is there a way to change the date format from the default of MM/DD/YYYY to DD/MMM/YYYY, example being today's date of 18NOV2016?
Cheers.
Parents
Former Member
I have the same problem. In my dev environment I have everything is on the one machine and the regional settings are dd/mm/yyyy but when I use a date in an auto calculation it changes to mm/dd/yyyy so it looks like the auto calc isn't honouring the regional settings.
To get around it I use a VB calculated value where I can split the date apart and rebuild in the desired format
I have the same problem. In my dev environment I have everything is on the one machine and the regional settings are dd/mm/yyyy but when I use a date in an auto calculation it changes to mm/dd/yyyy so it looks like the auto calc isn't honouring the regional settings.
To get around it I use a VB calculated value where I can split the date apart and rebuild in the desired format