Last month, this solution was given as a way to plug in the current date in a date condition… --------------------------
…you can use Oracle system date calculations in the enter Constant field on a date condition .i.e instead of typing 02/12/99 (today) you can type TO_DATE(sysdate,‘DD/MM/YYYY’)…
Listserv Archives (BOB member since 2002-06-25)