Date format turned into hashes

Help Activities
, , ,
1

Hello,

I get this output of date column after a Join Table output

image
image704×99 1.75 KB

And I find that it messes up the read range activities in future.
Before the Join Table output, the dates are shown in dd-MMM with a value of something like 04/25/2021. After the output the dates are now covered with hashes with a value of something like 04/25/2021 12:00:00 AM.

What causes the hashes to appear? and is there a way to prevent the Join Tables from changing the format?

2

@lmoham,

You could increase width of column in excel,
Go to Home => Format => Autofit Column Width.

i dont think so that could be the problem after reading it using read range activity.

3

Thanks for the lightning response!
and yeah widening the column widths seem to get rid of the hashes, I’ll just fix the formatting, much thanks on enlightening me :smiley:

1 Like
4

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