Hello,
I have a date prompt "date_from" and the last date has to be "today". Is it possible ?
yes try this
use this Filter
[Date_column] between ?From_date ? and SysDate()
I don't think you can set this value. What you can do is validate the date using javascript after the user has selected it.
Sriram.
http://www.cognosonsteroids.com
i found that script to set the default date as yesterday.
<script>
function subtractDay ()
{
var dtToday = new Date();
var dtYesterday = new Date( dtToday - 86400000 ); // 86400000 = 24 hours * 60 (minutes per hour) * 60 (seconds per minute) * 1000 (milliseconds per second)
var strYesterday = [dtYesterday.getUTCFullYear(), dtYesterday.getMonth()+1, dtYesterday.getDate()].join("-");
return strYesterday;
}
P_Date_from.setValue(subtractDay() );
</script>
P_Date_from is the name of my date prompt, but it doesnt work ?