Why does my field type keep changing in my select tool each time a new file is uploaded

[fmitchell50]

Hi

I have a workflow that brings in a file via dynamic input tool and the field type changes each time a new input file is used. The "date" types change back to vstring and the "double" type also change back to vstring. I tried "V'String- Forced" and "Date - Forced", still, it changes back to vstring when a new file is used.

Is there a way to keep the select tool field types without this issue? Is this issue related to the Dynamic Input tool?

The way that I have the workflow set up is it pulls the file from the folder it is in. The file has the same format each time so not sure why the select tool changes.

Thanks!

[lwolfie]

I find that changing data types from string to Date or Double, typically works best when you create a new field and use the DateTime tool under the Parse pallet and the ToNumber in the formula tool.  If you need to change multiple ones you can use the Multi-Field Formula tool.