In Ingres Report Writer, how do you prompt a user for an input value, but default to something should they enter blank? In particular, I want to prompt for a date, but default to today's date if blank...
I've tried the following in the .DECLARE section:
indate = date with prompt "Enter date (leave blank for today's date):" with value current_date
which doesn't seem to work.
Incidentally, is it possible to not allow a user to enter a blank input?