MS Dynamics POS: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value

Hi All,

I use MS Dynamics POS 2009 as my till and stock control system. I am having problems running reports.

When I try to run any report I get the error message in the attached picture.

I have lots or warnings on the till:

Event Type:      Warning
Event Source:      Microsoft Point Of Service
Event Category:      None
Event ID:      0
Date:            26/11/2010
Time:            14:17:13
User:            N/A
Computer:      CIT-MGAR-TILL01
Unable to load global configuration file.  Could not find file 'C:\Documents and Settings\All Users\Application Data\Microsoft\Point Of Service\Configuration\Configuration.xml'.

For more information, see Help and Support Center at

Let me know if you have any info. It is a great system but I have never been able to run reports.



Who is Participating?
illConnect With a Mentor Commented:
Agreed with cyberwiki.
You can change the format using SET DATEFORMAT SQL command. For example
set dateformat dmy
set dateformat mdy
It is possible your supplier has used regional specific programming, and your POS machine is not set up the same way.  Check with your supplier.
Hello, I was running reports just fine until a few days ago when I accidently edited the time on my computer.

Now it is giving me this anytime i run a report. Please help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.