Default todays date in parameter

[muffntuf]

Hi,

Has anyone ever been able to put today's date in for a default for a parameter based of a date field? Oh and have it show up in CE as a default too? I am using CR10 and CE10

Thanks,
muffntuf

 

[Ridyen]

I don't think you can actually pull today's date into the parameter. You can however set a default date for the parameter (say 1/1/1800)and include the parameter in a formula that is ultimately used to query your database.

Formula could be something like:

 beforereadingrecords;

if {?otherdateparm} > date("01/01/1800") then {?otherdateparm} else today

Mine was named @modified date.

Then just use the formula in your selection criteria (formula)

 {tablename.Per_End_DT} < {@modified date}

I hope that works for you.

 

[muffntuf]

Yes you can set the default to today's date. The parameter picks up todays date in the manual setting box, if you don't move anything over to the right side of the default settings it will always pop up with today's date.

thanks though, it took a few times to figure that one out.

muffntuf