Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Microsoft Dynamics POS...

Microsoft Dynamics POS 2009 - Reports are not working properly for dd-MM-yyyy format.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I am using Microsoft Dynamics POS in India. I am facing date format related issue while trying to view reports in Dynamics POS.

I am using Windows 7 OS. In my system date time format set is English(India). I went to Control Panel>Region and Language. There I could see my date format is set as English(India).

5444.Error.png

Now when I click on report for "Daily Sales By Category" in POS, it shows 0 values. This is because when I say date as 06/05/2014(6th May 2014), it is actually taking date as 5th June 2014. And if I change my date to 29/05/2014, it shows error: The conversion of nvarchar data type to a datetime data type resulted in an out-of-range value.

Here if I change my DateTime format to English(United States), then reports work fine. But I can't tell my client to change DateTime format when they need to view reports. Can somebody help me out to fix this issue?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Microsoft Dynamics POS 2009 - Reports are not working properly for dd-MM-yyyy format.

Set the format to MM-dd-YYYY. this is what POS 2009 uses.