AnsweredAssumed Answered

Query using Date

Question asked by Smills on Aug 10, 2009
Latest reply on Aug 10, 2009 by comment_1


Query using Date


I'm having a problem with the following formula:


If(Sampled Thawed="";If(BLEED DATE>6/16/2009;"Company";"");"")


The first part of the formula works but the date is messing it up the second part of the formula.  I won't recognize the date.  In excel if you turn the date to a value (i.e. 39880), it works but in FM it does not.  Help!