Power BI My Datediff formula keeps on giving me blanks

[Anonymous]

Hello Everyone, 

I am trying to take a formula from excel and translate it into power Bi. It looks like it working but I am getting blanks

Jan 19 Open Age = If(AND('FreshService Data RAW'[Created Date]<= 1/31/2019,'FreshService Data RAW'[Resolved Date] > 1/31/2019),DATEDIFF(1/31/2019,'FreshService Data RAW'[Created Date],Day))

I would love somone help. why is my formula not working?

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Jan 19 Open Age = If(AND('FreshService Data RAW'[Created Date]<= DATE(2019,1,31),'FreshService Data RAW'[Resolved Date] > DATE(2019,1,31)),DATEDIFF(DATE(2019,1,31),'FreshService Data RAW'[Created Date],Day))

[Anonymous]

@Greg_Deckler  

Thank you so much for the help, I changed it a little to not get negative numbers but it worked perfectly. 

[AlexisOlson]

@Anonymous Yep.

"1/31/2019" is not interpreted as a date but rather the number (1 / 31) / 2019 = 0.00001597724 which is equivalent to 12/30/1899 12:00:01 AM as a datetime value.

[Anonymous]

That makes sense, Thank you!