title: Sharepoint Calculated column formula for date-time comparison
body: <p>I have two columns C1 and C2, both of type date and time in a document library. Now i want to create a calculated column C3 using which i could know which column(C1 or C2) is having greater value. I tried following formula for calculated column IF(C1>C2, 1,0) it works perfectly fine, but if i replace C1 with 'Modified' column it doesnt seem to work.
  Please use different datetime values for C2 to get 1,0,1,0 in calculated column. I noticed that after 2-3 operations it remains either 1 or 0.   </p>