Auto-substitution of dates

Question

Hi! I have a small but annoying problem concerning the auto-substitution of dates. After updating to SR-2 or Windows 10 (I&acute;m not sure which), Studio has started to auto-substitute dates in the wrong form. I have checked the box for dates under Language pairs - Auto-substitution, but there doesn`t even seem to be the right alternatives there. This wasn&acute;t a problem before. I need the dates to be in the form 9.3.2016 but Studio gives me 9-3-2016. Do you know why this could be?

Paul · Answer

Hi Linn, 
 
What language pair are you working with? 
 
If we can't find the simple solution in the settings then the problem isn't too hard to handle anyway. If you allow Studio to do its thing and handle the numbers for you then the dates should all be good (just not formatted correctly for you), So after you're done you can search and replace the format in one go. 
 
Use regular expressions and search for this: 
 
(\d+)-(\d+)-(\d{4}) 
 
Then replace with this: 
 
$1.$2.$3 
 
This way you can replace them all as you need them in one go at the end. But let me know what languages so I can test this and see whether we can tweak the settings as you need them first. 
 
Regards 
 
Paul

Steve Rawcliffe · Answer

Although this is a very old post, it's perhaps worth pointing out for the benefit of other users that if the date format has also changed in Excel then this is a Windows setting, which you can fix via Control Panel>Region>Date.

Trados Studio > 1. Trados Studio

Auto-substitution of dates