Hello All,

I Have to fields in the Database.

{Add.date} and {void.add.date} and im trying to display records from both if they equal today.

I was filtering on if {Add.date} = today () it will come up fine

but if a void is done it will populate the {void.add.date} and leave the {add.date} as the original day done which could be weeks ago.

anyway I can do it so if a void is done it display that date instead.

NOTE: the {void.add.date} field is Blank when no voids are done.

cheers all.

where would I put this formula tho?