< Today in a AdHoc Function?

[handleAKA]

I have a date/time field I want to show up in a report only if it is < the day the report is run.
(I've tried Now(), Date[$] IsDate.) Any help or ideas would be Great.

 

[milton747]

Conditionally populating a control is done in the OnRow() method of the control itself. In your case, the date field.

Can you insert some code that test the value of the DataRow date field, against NOW() and only set the field if it's < NOW().

Pseduo

OnRow()

IF Not getvalue() < NOW() THEN ' Ensure formats are same
DataValue = Spaces ' DO not show date
END IF

 

[handleAKA]

Thanks for you help what I ended up doing was;

On the NewReportApp on the methods
On sub Start() I added

TODAY = Now()

I then added TODAY to my Parameters

Then I put in the adHoc field as <:TODAY

Crazy but it works fines.