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!