Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Error in date format while downloading it into excel

Former Member

‎2010 Jul 14 3:08 PM

0 Likes
422

Hi Experts,

I created a report and when i download date from report to excel the date format is getting reversed.

FOR example Date in REPORT : 07//2010

IN EXCEL: 201007

Kindly give some idea to resolve this issue.

Regards,

Vishwa

Hi Experts,

I created a report and when i download date from report to excel the date format is getting reversed.

FOR example Date in REPORT : 07//2010

IN EXCEL: 201007

Kindly give some idea to resolve this issue.

Regards,

Vishwa

Reply
2 REPLIES 2
Read only

Former Member

‎2010 Jul 14 4:14 PM

0 Likes
362

hello,

Please change the data type of date field to Character (C).

and pass the required date value.

It shouldl make correct output to excel...

Thanks.

Read only

matt
Active Contributor
In response to Former Member

‎2010 Jul 15 9:06 AM

0 Likes
362

Despite being a date question, I'm letting this one pass. But it's right on the border of what's acceptable and what isn't. If there's too much spoon-feeding, I'll lock it.

matt