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
Hi thanks for answering. I need to do the same thing but replace [Actual End Date] with Today() or something which works simular:
if (DateTime.Now() < ([Target End Date] ?? #date(1,1,1)) then 1 else 0Something simular to above should work. Any support?
if (DateTime.LocalNow() <...
--Nate