Dear @ChanuteJo ,
Did you look into @Harveer_SinghGi1 's reply?
If you identify the source field string, then you can modify your FORMAT accordingly.
Example: If your string is '20250131', your format has to be 'YYYYMMDD'; if your string is '2025 01 31 00:00:00', your format has to be 'YYYY MM DD HH...