custom Excel columns of the reports

[didina]

I guys,
how can I custom the Excel columns of the reports (when I export excel)?
In the excel there is this format for date '2015-03-19T09:07:53+0000'
and I would only this 2015-03-19.
How should I do?

[Shobhit Tripathi]

Hi,

You are facing this problem because of report widget contains the date column with Time-stamp.

You can achieve it by following ways:

1. While saving/pushing the records into the collection you can use only MM/dd/yyyy. So that it will export the file as per proper format(required).

2. If your requirement is- you wanted to show the records in the report widget with Time-stamp then you have to use the JavaScript on button(with action as Execute Script) which will execute after clicking on it.Inside the JS you have to use the code which will fetch all the values (with date format as per your requirement) from the collection and create.export the file. 

3. You can also modify your exported file's column as per required date format cell inside the file (if any) provided by the vendor.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/8c61ec22-5a0e-4d56-a42e-76dffc0c87b5%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

Thanks & Regards,

Shobhit

Fujitsu- RunMyProcess