date prompt last date

[philelmousse]

Hello,

I have a date prompt "date_from" and the last date has to be "today". Is it possible ?

[HalfBloodPrince]

yes try this
use this Filter

[Date_column] between ?From_date ? and SysDate()

[absriram]

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

[philelmousse]

i found that script to set the default date as yesterday.

Code Select Expand

<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 ?