How to prevent import date cell formatting to CSV?

Question

Hi

The date cell formatting is exported to the CSV file. When I hit "download report as CSV" the formatting for date cell is saved into the CSV file showing this:

<span style="white-space: nowrap; "><span style="color: blue; font-weight: bold; white-space: nowrap;">06-17-2022</span></span>

How this can be prevented or resolved?

Thank you,

------------------------------
Karwan Fendi
------------------------------

PrashantMaheshw · Answer

HI Karwan,the field which is being downloaded is actually a RichText formula, which is how you can see colourful blue number. To prevent/ Resolve this, you can create download the original field which this may be referring , it should be date field OR you can create another field which is a date formula and do the same calculation being done in RichText formula------------------------------Prashant Maheshwari------------------------------

Sign up

Login to the community