If Function

  • Thread starter Thread starter tk
  • Start date Start date
T

tk

i want to add a if function to a report. However Im not sure how to do
it.

If the date of a course is greater than a month then i want it to
display the message:
"Please not that this invoice contains payments which have been
outstanding for over three months."
But if its not then i do not want it to display anything
 
Create a text box on your report with the following for your data source:

=iif([CourseDate]<Date()-31,"<<Type your message here>>","")

I assume that you mean if the course date is older (greater) than 30 days
past the current date, you want the message to appear.

You can change or set your reference date to any field by substituting that
field name for Date(), or extend the range, obviously, by modifying 30 to
whatever range you want.
 
Back
Top