four digit year in RDA
I am creating UBE where one of the date field has a value of 1/1/40. The UBE also exports to csv. When I export to csv, I noticed that the 1/1/40 changes to 1/1/1940. I did some research and found out that it's due to Microsoft 2029 rule.
I created a custom data dictionary date with size of 8 xx/xx/xxxx. However when I go into RDA, I see xx/xx/xx. What do I need to do to be able to see xx/xx/xxxx in RDA without changing user profile?
We want to avoid changing the user profile because that is a global change which will affect all grids and reports.