• Accurate question. I think any question that uses a date with obvious notation to remove all ambiguity such as '2010-Jan-01' is fine. We clearly understand which is the year, month, and day. '201000205' while most would consider it to be February 5, 2010; 5 February 2010; or 2010 Februrary 5 it isn't perfectly clear.

    I would have liked to seen this instead:

    DATEADD(MONTH, 1, '2010-Jan-30')

    Feb 28 is correct not Feb 27 day preceeding end of month nor March 1 30 days post Jan 30.

    Tim