Inconsistency with DateTime and accepted Operators?
I'm new to PowerBI and PowerQuery so this problem I've run into is really confusing me. What I'm trying to do is get a count of tickets created within the last 14 days and eventually plot the amount of issues per day against a chart. The second formula, a natural progression from my first formula, produces an error message that would make me think the first formula can't be valid, hence the confusion. That said...
Why does the valid formula below accept operators >, <, and =...
= if [CreatedDate] > DateTime.Date(DateTime.LocalNow()) then "1" else "0"
...But the next formula will spit an error if I use greater/less than operators:
if [CreatedDate] > Date.AddDays(DateTime.LocalNow(), -14) then "1" else "0"
The error I get is
"Expression.Error: We cannot apply operator < to types DateTime and Date. Details: Operator=< Left=5/11/2017 5:19:17 PM Right=10/11/2014"
The error message can't be true since the first formula was accepted and produce the expected results. Any thoughts?