Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Date Showing Up Different in MS Dynamics CRM than that of SQL-Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    My string dates are as follows in YYYYMM format:

    201008
201009
201010
201011
201012
...

    The following is my CONVERT statement in my stored procedure:

    CONVERT (datetime, @FileName + '01', 112)

    my results are showing up fine in SQL-Server as follows

    2010-10-01
2010-11-01
2010-12-01
...

    However, in MS Dynamics CRM they are showing up as the last day a month earlier (corresponding with the previous SQL-Server results) as follows:

    9/30/2010
10/31/2010
11/30/2010
...

    What the heck is going on here?

    Thursday, March 20, 2014 11:00 PM

Answers

All replies