conditional select formula

[rbenson1]

I have a custom paramater that has several defined values that a user can select. Then I have a formula that uses a select statement to determine what the user selected and run the appropriate select formula.

How can I have one of the case blocks not perform any record selection and return ALL records?


Code:

select {?Dates}
case 1:
  'Show all dates, this is the one I cant figure out
case 2:
  {@GroupDate} in WeekToDate
case 3:
  {@GroupDate} in MonthToDate

Any help is appreciated, Thanks!

 

[Turkbear]

Hi,
use a default date as Case 1 that is an obvlious 'flag' to return all ( the Description could be ALL :
Then

select {?Dates}
case 1:
  True 
case 2:
  {@GroupDate} in WeekToDate
case 3:
  {@GroupDate} in MonthToDate

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[rbenson1]

Thanks Turkbear, works like a charm. I knew the solution was easy, I just couldn't drum it up...