Difference between revisions of "Adding a given number of days to a date based on the value of a dropdown"

From SmartWiki
Jump to: navigation, search
 
Line 1: Line 1:
 +
==Problem==
 +
A date must be displayed which is a number of business days after a date shown in an existing field. The number of days to be added will vary depending on the value of a [[Custom Field Type: Select One – Combo Box|dropdown field]] elsewhere on the page.
 +
 +
==Solution==
 +
Create a [[Custom Field Type: Special – Calculated Value|Special – Calculated Value]] custom field with expressions equivalent to the following:
 +
 +
===Where the date to be added to is a custom field with a [[customfieldid]] of 12345 and the dropdown list is named ''Client Category''===
 +
[Client Category]=='Regular'?busdateadd(frm.cf_12345.value,10):[Client Category]=='Under Investigation'?busdateadd(frm.cf_12345.value,5):[Client Category]=='Special'?busdateadd(frm.cf_12345.value,30):'0000-00-00'
 +
===Where the date to be added to is the [[standard field]] "Start Date" and the dropdown list is ''Time Line''===
 +
[Time Line]=='Regular'?busdateadd(frm.startdate.value,10):[Time Line]=='Under Investigation'?busdateadd(frm.startdate.value,5):[Time Line]=='Special'?busdateadd(frm.startdate.value,30):'0000-00-00'
 +
 +
The
 +
 +
 +
==See Also==
 +
* [[Calculated Value - busdateadd Function]]
  
 
[[Category:JavaScript]][[Category:Date Formats]]
 
[[Category:JavaScript]][[Category:Date Formats]]

Revision as of 15:57, 8 November 2013

Problem

A date must be displayed which is a number of business days after a date shown in an existing field. The number of days to be added will vary depending on the value of a dropdown field elsewhere on the page.

Solution

Create a Special – Calculated Value custom field with expressions equivalent to the following:

Where the date to be added to is a custom field with a customfieldid of 12345 and the dropdown list is named Client Category

[Client Category]=='Regular'?busdateadd(frm.cf_12345.value,10):[Client Category]=='Under Investigation'?busdateadd(frm.cf_12345.value,5):[Client Category]=='Special'?busdateadd(frm.cf_12345.value,30):'0000-00-00'

Where the date to be added to is the standard field "Start Date" and the dropdown list is Time Line

[Time Line]=='Regular'?busdateadd(frm.startdate.value,10):[Time Line]=='Under Investigation'?busdateadd(frm.startdate.value,5):[Time Line]=='Special'?busdateadd(frm.startdate.value,30):'0000-00-00'

The


See Also

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Adding_a_given_number_of_days_to_a_date_based_on_the_value_of_a_dropdown&oldid=20331’