Is there a way to format a date field that is coming from a report in Salesforce and being merged into Excel? Currently when I merge the report into Excel the date field is changed to Text in Excel and I must manually change it back to a date.
Best answer by ryan_oleary
View original
+17
?Hi Tomasz, the document is being generated with Drawloop Document Generation. It pull the data from a Salesforce report.
+17
now that is a different story. Moderator approved 
I haven't been testing Excel generations, but isn't it the case, when at point where you set up your template, you set proper formatting to the column in which you expect to have "date" then?
regards,
Tomasz
I set the format to Date in the template but it gets overridden when the file is created.
Justin Cairns | Salesforce
Ph: 913-747-4778 |E: jcairns@tafs.com<mailto:jcairns@tafs.com> | Web: www.tafs.com<http://www.tafs.com/>
15910 S 169 Hwy, Olathe, KS 66062
<http://www.tafs.com/>
Hey Justin,
I would recommend putting in a dummy date into the cell. We'll over ride that date when the data is merged in and the formatting will persist.
Please let me know if you have any other questions.
Cheers,
Ryan
That worked. Thanks.
Justin Cairns | Salesforce
Ph: 913-747-4778 |E: jcairns@tafs.com<mailto:jcairns@tafs.com> | Web: www.tafs.com<http://www.tafs.com/>
15910 S 169 Hwy, Olathe, KS 66062
<http://www.tafs.com/>
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
