Forum Discussion
Create a new column on if statement(Very basic support needed)
Hi im trying the most simple query. Any help? if ([Actual End Date] < [Target End Date])
then 1
else 0 If date1 is less then date2 then put 1 in the column otherwise put 0...
if ([Actual End Date] ?? #date(1,1,1)) < ([Target End Date] ?? #date(1,1,1)) then 1 else 0
if ([Actual End Date] ?? #date(1,1,1)) < ([Target End Date] ?? #date(1,1,1)) then 1 else 0Ahh never thought to use the ?? In an if comparison--very cool.
--Nate