Forum Discussion

Sankha's avatar
Sankha
Frequent Visitor
7 years ago

Date format while export in excel

Hi All,   I am facing an issue while exporting data in to excel. In report I am able to trim timestamp  of a datetime field by using format() and also able to change the format as I like.   But o...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

How you store the data and how the data is formatted are two completely different things.  Its likely the issue you are facing is a formatting problem.

 

If you are using the FORMAT function, you can also specify how it displays.  This is done by placing a format string into the "Format" parameter of the FORMAT function.  An example might be:

=FORMAT(A1, "DD-MM-YYYY")

 

 

In Power BI, you could do something similar, but it will store your data as a String rather than the Date type.  Power BI has inbuilt formatting functions which has a "dd-MMM-yy" format which is the closest to your requested display format.

 

  • Sankha's avatar
    Sankha
    Frequent Visitor
    7 years ago

    Thanks very much for looking into this and your reply. 

     

    If I use FORMAT (A1, "DD-MM-YYYY") it is displayed as expected in the report. Thats fine but once I exported the data into excel and opening the excel,  it always showing as DD/MM/YYYY.  Can  this data not get saved in the excel  as DD-MM-YYYY format?