Comparing Dates in Custom Formula

Comparing Dates in Custom Formula

I'm creating a Custom Formula Column in a table that will compare the value of dates and return a value.  I'm unable to figure out the proper syntax when working with dates.  This seems very simple, but I can't find any reference on this site .

I'm trying to get a simple formula to work.  Pls advise on the proper syntax for the following statement.  Right now, this returns 'False' regardless of the date.

if(CloseDate>'October 30, 2010','Current','Past')
... also tried
if(Status='Sold',if(CloseDate>'2010/10/30','Current','Past'),null)
... and other combinations

Also, can you refer me to a 'help' reference for creating custom formulas?

Thanks.