Trim Date from file name windows script

How do you trim the date from a text file. For example, I have multiple files like:

• 
  

  test_MX_abc_20091011.txt

  
  


• 
  

  test_MX_pqrdhdsu_20091011.txt

  
  


• 
  

  test_MX_xyieuz_20091011.txt

  
  

All files will have test_MX in common but the 3rd part will of different size.

I would like to change into:

• test_MX_abc.txt


• test_MX_pqrdhdsu.txt


• test_MX_xyieuz.txt

I know how to change the file if name is like test_20091011.txt with the below code, But if name has more string along with date, how to do that?

for /F "tokens=1 delims=_" %%i in ("%%~na") do (
     move /Y %%~fa %data_in%\%%i%%~xa >nul
)

Thanks in advance.