Filter data table pasting Date Columns as Values instead of Text

Dear All,

I have used build data table and filter data table activities to select a few columns to create a smaller excel sheet from a larger one. The date columns are all pasted as “values”. I would like them to retain the date format in the new Data Table as well.
please advise

Hi @preetith if this is a one -off correction,record a small macro where you are changing the format of the output column back to the date format. Run that macro using UiPath at the end of your code using invoke VBA activity.
Hope this helps.

This is useful info. I will try this from next time. Thanks !

I solved it by using “preserve format” while using “read range”. I believe it slows down the process but my excel sheet is not formatted with colors and such, so seems ok.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.