AnsweredAssumed Answered

Query using Date

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

Title

Query using Date

Post

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!

Outcomes