Forum Discussion

KarwanFendi's avatar
Qrew Member
2 years ago

How to prevent import date cell formatting to CSV?


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

1 Reply

  • 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