Discussions

 View Only
  • 1.  How to prevent import date cell formatting to CSV?

    Posted 07-25-2022 10:00
    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
    ------------------------------


  • 2.  RE: How to prevent import date cell formatting to CSV?

    Posted 07-25-2022 11:43
    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
    ------------------------------