Sage ACT!
  • Contact Us
  • Sage North America
  • Buy Now or Call 866-873-2006
Community Twitter Facebook LinkedIn
Community Home Blogs Share Ideas Search Request Access additional resources
Reply
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 1 of 18 (1,798 Views)
Accepted Solution

The string was not recognized as a valid datetime

I have a user:

  •   ACT PRO 2011 Version 13 HotFix2 (New Zealand)
  •   Windows 7

When opening ACT!, we get this error:
"The string was not recognized as a valid datetime. There is a unknown word starting at index 5"
If you click OK it seems to be fine... except:

When the user goes to schedule a CALL or MEETING a dialogue pops up saying:
"Resolution of the dependancy failed, type = "ACT.ULAvailControl" name = "Eception message is: The current build operation (build key Build Key{Act.UL.AvailControl, null}; failed. The string was not recognised as a valid Date Time. There is a unknown word starting at index 5. (Strategy type BuildPlanStratefgy, index 3)”

Any ideas?

Please use plain text.
Moderator
ghollister
Posts: 4,100
Country: USA
Message 2 of 18 (1,794 Views)

Re: The string was not recognized as a valid datetime

Hi Mike,
Does this happen with the Demo database or a new database? It sounds like an invalid value in the database, possibly a date field or in the Activity Types list. It may also be a conflict with the regional date/time settings on the machine.

Greig Hollister
Moderator
Sage ACT! Online Community

Please use plain text.
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 3 of 18 (1,775 Views)

Re: The string was not recognized as a valid datetime

One person said they heard it was a "known issue" with Mexico and New Zealand regional settings and there was a workaround.

Any chance you could check that?
Please use plain text.
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 4 of 18 (1,730 Views)

Re: The string was not recognized as a valid datetime

Sage Australia's solution was to close and re-open ACT! before every update to an activity...

I have found a MUCH simpler and permanent solution and will be posting it to my blog later
Please use plain text.
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 5 of 18 (1,729 Views)

Re: The string was not recognized as a valid datetime

Please use plain text.
Nickel Super Contributor
gleo
Posts: 807
Country: New_Zealand
Message 6 of 18 (1,727 Views)

Re: The string was not recognized as a valid datetime

[ Edited ]

Greig,

This bug was identiifed about 13th September and is slated to be fixed in SP 1. Defect # 93519

Graeme Leo
graeme@xactsoftware.co.nz
Xact Software Solutions
ACT! Certified Consultant and ACT! Custom Developments
* Xact Software - www.xactsoftware.co.nz - Linking ACT! and Quickbooks*
* TIME & BILLING for ACT! - keep work flowing - an InsideACT! Add-on*
* ACT! Workflow Solutions for QuickBooks, Xero, MYOB EXO and MYOB *
* WWW.FREEACTADDONS.COM - Useful Tools for ACT! at no cost - *
Please use plain text.
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 7 of 18 (1,717 Views)

Re: The string was not recognized as a valid datetime

At least now there's a nice simple fix.

Shame no-one in NZ beta tested it early enough to get it fixed in the gold release
Please use plain text.
Copper Super Contributor
jpenney
Posts: 56
Country: New_Zealand
Message 8 of 18 (1,693 Views)

Re: The string was not recognized as a valid datetime

Mike the problem was not in the Gold version as far as I know, I first noticed it after HF2 was released.   It was then common in any new installs.

 

I couldn't get a copy of the Beta to test so cannot be sure if there was a problem in testing.

 

Greg, we seem to have at least three separate threads covering this MP/94484-#M18072; MP/98276 -#M40291 and one other which came up with the AM/PM vs a.m./p.m.  change to regional settings.

 

Would seem logical to combine  all threads or at least  generate a link to each .

Please use plain text.
Copper Super Contributor
jpenney
Posts: 56
Country: New_Zealand
Message 9 of 18 (1,691 Views)

Re: The string was not recognized as a valid datetime

Greg,

 

The problem was in the local databases and in the ACT! 2011 Demo Database  in the Australia/Asia version.

Please use plain text.
Platinum Elite Contributor
GLComputing
Posts: 11,670
Country: Australia
Message 10 of 18 (1,688 Views)

Re: The string was not recognized as a valid datetime

Jim,

 

Graeme said it was identified in September ... thet's the Gold version

Please use plain text.
 
 
Bookmark & shareBookmark & share