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

  • Question

  • 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