Jochem wrote:
i now have this function but the same result
can you give me a hint how to use the make date??
sum({tiny_mce_markerlt;Budget_BeginDate={"<=$(=DATE(Reak_Date,'DD-MM-YYYY'))"},Budget_EndDate={">=$(=DATE(Reak_Date,'DD-MM-YYYY'))"}>}Budget_value)
<div></div>
You have to use makedate during the load script.
Makedate(
year, month, day
)
So if your input is 01-31-2008, your makedate formula would be makedate(subfield(
field_name, '-', 3), subfield(
field_name, '-', 1), subfield(
field_name, '-', 2)).
Jochem wrote:
can you please have a look at the other post (problem2.qvw) because in this example i changed the date to numbers, and this also does not work!<div></div>
I can't quite figure out what happened in this one, but your syntax is not correct. I think this is what you were trying to accomplish...
sum({$<Budget_Begin = {'<=$(Real)'}, Budget_End = {'>=$(Real)'}>} Budget_value)