Forum Discussion

KarwanFendi's avatar
KarwanFendi
Qrew Member
3 years ago

How to prevent import date cell formatting to CSV?

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
------------------------------
Data import and export
  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    3 years ago
    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
    ------------------------------