DATE function does not work correctly until Feb 29, 1900 - by Marco Russo

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 769455 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 11/1/2012 9:12:40 AM
Access Restriction Public


The DATE function in DAX does not generate correctly dates between Jan 1st and Feb 28th 1900
Sign in to post a comment.
Posted by Microsoft on 11/6/2012 at 9:15 AM
hanks for filing this. The problem is due to our effort to be fully compatible with Excel. In order to accomplish that, we are only able to support dates beginning with March 1, 1900. Dates prior to that are not supported in this product.

Analysis Services Product Team