Community
Showing results for 
Search instead for 
Do you mean 
Reply

Opportunity user field formatted as a date exports the wrong date to Excel

Silver Elite Contributor
Posts: 3,344
Country: United_Kingdom

Opportunity user field formatted as a date exports the wrong date to Excel

If I format an Opportunity user field as a date, everything looks OK when you enter a date in the field, however, if you export to Excel from the Opportunity list view the date in Excel is for the previous day, so 24th October 2008 appears as 24/10/08 in ACT, and 23/10/08 in Excel.

 

Is this a special feature of the UK version or does it apply to the rest of the world as well?

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Opportunity user field formatted as a date exports the wrong date to Excel

What version of ACT! (the full build from Help | About)?

 

I seem to remember a similar issue with the Ops List in 10.0.0 and 10.0.1... I think it might have been fixed in 10.0.2

Silver Elite Contributor
Posts: 3,344
Country: United_Kingdom

Re: Opportunity user field formatted as a date exports the wrong date to Excel

ACT! by Sage Premium 2009 (11.0) Version 11.0.0.367  !!
English (United Kingdom)
Sage Software, Inc.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Opportunity user field formatted as a date exports the wrong date to Excel

What version of Outlook?

 

I'll see if I can replicate it when I have time in the next week

Silver Elite Contributor
Posts: 3,344
Country: United_Kingdom

Re: Opportunity user field formatted as a date exports the wrong date to Excel

Doesn't seem to make any difference which version of Excel you use, the problem is with ACT. I get the same with Excel 2003 and 2007.

 

The date number is just wrong.

 

 

Excel Cell Format___    Date entered in ACT! is 25 October 08

General  Date    

39746     25/10/2008   Exported from a Contact Field

39745     24/10/2008   Exported from a Opportunity User Field

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Opportunity user field formatted as a date exports the wrong date to Excel

Ok... I have replicated this with the AU version of ACT! 2009, Office 2007 and AU regional settings.

 

The dates are OK for the standard fields (Edit / Create / Esimated Close, but a day early for date fields in the custom area.

 

Would like someone with the US version to see if this is the same for them

Moderator
Posts: 4,395
Country: USA

Re: Opportunity user field formatted as a date exports the wrong date to Excel

Unable to reproduce in US version.  I will look into it and report the issue if necessary.
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Opportunity user field formatted as a date exports the wrong date to Excel

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Opportunity user field formatted as a date exports the wrong date to Excel

I wonder if this is the international date format or actually code in the int'l versions?

 

David, if you do any testing, remember to try both

Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Opportunity user field formatted as a date exports the wrong date to Excel

Mike

Here's a SWAG. I think the GMT offset is not applying correct when the data is exported to Excel. I suspect that it is correct for GMT minus zones which would include the Americas but has problem with the plus zones.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129