Date Field within a report

[Dineedshelp]

I have created a report which basically produces an invoice. Within this invoice are two date fields, if the mileage field is equal to four, these date fields need to remain blank, this I have solved. My problem is that, when the mileage field isn't equal to four, the date needs to be shown, an added problem being that the only way to show this date field is to use this:

DTSToTimeField ({Invoice_Detail.Start_Time})

But the above won't be accepted with the formula I have devised:

If {Invoice_Detail.Rate_Type} = 4 then "" else ?????????

(rate type being the mileage).

Basically I need the final result to either be blank or show the time as 08.00AM

 

[PatrickIRL]

Hi,

On the report, right-click on the date field, select Format Field and from the next screen make sure the Suppress checkbox is toggled on. Click on the X+2 button on the right and in the editor insert {Invoice_Detail.Rate_Type} = 4. This will supress the field from printing when the condition is met.

Post back if you have any problems