MyDate >= DateStart and MyDate <= EndDate ; MyDate ;
Or with no extra calculation field you could use a conditional format to show it as white text if
MyDate >= DateStart and MyDate <= EndDate
I entered the following but it would not work the fields that I used are all date fields.
Case ( SiteProduct::ReChargeCalculation > = NextInspectionDueDate and SiteProduct::ReChargeCalculation < = __CalcInspectionPlusOneYear ; SiteProduct::ReChargeCalculation;"")
SiteProduct::ReChargeCalculation = Date I need entered on report
NextInspectionDueDate = Start date
__CalcInspectionPlusOneYear = End date
Would you mind creating a custom dialogue, and as the calculation for the body of it, use this:
"ReChargeCalculation: " & SiteProduct::ReChargeCalculation & "¶"
"Next inspection due date: " & NextInspectionDueDate & "¶"
"Start date (inspection): " & NextInspectionDueDate & "¶"
"End date (inspection): " & __CalcInspectionPlusOneYear
This will help debug what the values are in the parameters that it is using. If you want us to look at it you could post a screen shot of how the dialogue looks.
Does the same Start Date and End Date apply to every record? - in other words should these be global fields, or are they different start and end dates for every record?