+ Start a Discussion
kiran punurukiran punuru 

How to remove timestamp and display only date

Hi All,
I have created one component which will generates an excel with opportunity fields now i need to display only date instead of datetime in excel how can i achieve this :
Now in the generated excel it is displaying as: Mon Jan 31 09:37:37 GMT 2016
I  need to display like this:31/01/2016
Shaijan ThomasShaijan Thomas
Create a formula field, get the date field in the formula and convert it to date then export to xls