Getting the DataType of a Specific Column in a Data Table

[Luis_Fernando]

Here it is…
DateDemo.zip (11.4 KB)

You can always check this topic where I shared my results with every Preserve Format configuration on the Date Format.

Read Range stays pending & Date conversión issue

Hello @Parvathy, Thank you very much for your response. I have to admit I feel pretty embarrassed , Yesterday was a complicated day and I guess I still forget the basics and check the properties of the activities very carefully. I guess I have no trouble consulting the forum every time I need something. Yet with the answers on the topic I started testing the different configurations available mostly for the Excel activities (That worked better for my case), an…

There is also a Workflow called Filtering that examples the filtering with DataTable from Read Range Workbook where both Preserve Format throws System.Object DataType but the filtering only works when the configuration is false. I think you already addressed this issue on your last reply, but I’m not sure if I got you quite alright. Do you mean that when Preserve Format is True the whole column DataType is Object but every value individually is treated as a string? where in false are treated as objects? If that’s so, you can ignore that workflow

Thank you once again