I found something which may help some people who want to append formua

[mintman]

hello friends, if you want to append the formula values into parameter this is the way
Go to the database expert and then command in that enter
(CASE
WHEN "IDCASE00"."IDDCR" <> '' THEN
({fn SUBSTRING("IDCASE00"."IDDCR",1 ,4 )} || '-' ||
{fn SUBSTRING("IDCASE00"."IDDCR",5 ,2 )}|| '-' ||{fn SUBSTRING("IDCASE00"."IDDCR",7 ,2 )})
END) IDDCR , along with your other values. Hope this helps.
Here IDDCR is a number value Im converting to Date format.
Thanks,
Reed

 

[synapsevampire]

This post, like the original question, didn't make sense, hence the lack of responses.

To use a Command Object as the source for a parameters values (what you call appending formula values), you would need a select statement, which this does not.

Also depending upon the database type, which you should include, you should convert it to a date field, rather than a string in the format of a date.

-k