Skip to Content
0
Former Member
Jun 01, 2011 at 04:27 AM

Query Designer Formula Logic

34 Views

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