Pass variable in Dateadd() function

Report · May 17, 2013

Hi,

I want pass a variable for number part in Dateadd() funtion instead of hardcoding it.

Eg:

now i want to pass this value of a into "number" part of dateadd function.

DateAdd("d", number, now())

How can be this done..?

Report · May 18, 2013

<cfset newDate = DateAdd("d", a, now())>

Report · May 19, 2013

i tried that.but getting error

Report · May 19, 2013

gokul1242 wrote:
i tried that....

No, you didn't. What you tried is equivalent to:

You will find that the following does work:

Report · May 19, 2013

Yes

This works. But in my case i am calling txt_expiration value from a sql query through js script as follows

function fnselectcat()

{

if(qj.getField(i,"cat_id") == document.frm.sel_category.value)

{

document.frm.txt_expiration.value = qj.getField(i,"CAT_EXPIRATION");

}

</SCRIPT>

how to fetch the "txt_expiration" value from script and pass it into the date funtion ??

Report · May 20, 2013

Javascript runs on the browser, ColdFusion on the server. Hence, Javascript variables are not available to ColdFusion.

You are apparently aware of one way of passing the variable to ColdFusion, namely, by submitting a form. The variable is then available on the form's action page as form.txt_expiration.

However, I was wondering why don't just do the obvious. Get the value of txt_expiration directly from the query!

Report · May 20, 2013

the scenario is i have a drop down.based on selecting the drop down value it calls the above onchange js function to display the corresponding

txt_expiration value .but txt_expiration values are in days(eg: 180,365) in db..i need to add it to current date ie now() and convert it and display in dd-mm-yyyy format

Report · May 20, 2013

Run the following test. I hope everything will then become clear. Both CFM pages are within the same directory.

testFormpage.cfm

function fnselectcat()

{ document.frm.txt_expiration.value = 'KARAMBA!';

document.frm.submit();

}

</SCRIPT>

</form>

</body>

testActionpage.cfm

The form has been submitted and the value of form.txt_expiration is: <cfoutput>#form.txt_expiration#</cfoutput>

</cfif>

Adobe Community

Pass variable in Dateadd() function