Topic: Supress Field based on Date Posted: 23 Mar 2015 at 5:10am
Hello all,
I hope someone may be able to help?
I have a text field which I would like to suppress based the dates in three other fields and in relation to the current date.
For instance I have three date fields A,B,C in the report.
If the report is run at any point during March and any or all of the date fields (A,B,C) contain a date from the previous month, February then the text field is visible, otherwise it is suppressed.
I can get it to work for a date field using the formula DateAdd ("m", -1, CurrentDate), however I cannot the syntax correct to include the others.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum