Date Formula Glitch

[dunkyn]

Based on the date parameter, I am looking up values given the selection criteria and formulas below, and getting inconsistent results.


/////////////////////////////////////////////
Select Expert Criteria
{Table.DateField} = {?AsOfDate}

//////////////////////////////////////////////////
@Formula1

Select {Table.DateField}

Case Date (2003,1,1) to Date (2003,1,31):1
Case Date (2003,2,1) to Date (2003,2,28):2
Case Date (2003,3,1) to Date (2003,3,31):3

Default: 0

/////////////////////////////////////////////////////

@Formula2

Select{@Formula1}

Case 1:13.9
Case 2:13.5
Case 3:13.8

Default: 0


It is strange, because a date parameter of 3/4/2003 will give me the correct values, but a date of 3/31/2003 produces nothing ?

Any suggestions?

 

[dunkyn]

Resolved. In Formula1 I need to use my date parameter field instead of the database field, as the database is not fully populated for all dates.