Hi
I have the following data and the status of the formula should be 1 or 0.
Cancel Date : 05/31/2011
Formula : cancel date >=today's date
Cancelled(Yes =1/No= 0) : 1
Cancel Date : # (no date assigned)
Formula : cancel date >=today's date
Cancelled(Yes =1/No= 0) : 0
Cancel Date : 06/30/2011
Formula : cancel date >=today's date
Cancelled(Yes =1/No= 0) : 0
i tried the following formula in the query designer 7.0 but second condition gives 1 instead of 0.
DELTA ( COUNT (cancel date >= today's date)).
I am not able to find a better solution, please suggest.
Thanks!
Edited by: bwcrm01 on Jun 1, 2011 6:28 AM