Forum Discussion

KarwanFendi's avatar
KarwanFendi
Qrew Member
2 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: nowr...
Data import and export
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
2 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
------------------------------