Changes

Adding a given number of days to a date based on the value of a dropdown

1,164 bytes added, 19:57, 8 November 2013

no edit summary

==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]]

• ← Older edit
• Newer edit →

Arthur Lathrop

8,849

edits