Changes

Jump to: navigation, search

Manipulating Dates

304 bytes added, 14:13, 4 April 2014
no edit summary
{{JavaScript Syntax}}The following [[JavaScript]] functions are built-in to SmartSimple to assist when working with and performing calculations using dates:
==ConvertDateStr==
'''Syntax:'''<br>
:<font size="3">'''ConvertDatessConvertDate(''date'','fromdateformat','todateformat')'''</font>
'''Where:'''
::* 'd' (days)
::* 'm' (months)
::* 'yyyyy' (years)
* ''interval'' is the number of days/months/years to be added.
var newDate=dateadd(sdate,'m',duration);
 ===Example===
The following example adds a specified number of months (saved in cf_123456) to the startdate, and saves it as the enddate.
frm.enddate.value=ssConvertDate(edate,"@dateformat@");
</pre>
 
==Notes==
* When using [[JavaScript]] to populate a date it must be added to the field in the preferred date format of the current user, as the system will automatically convert it to yyyy-mm-dd when the page is saved.
 
* To change the display format of dates displayed on the page see [[sscalculation]]
* [[isHoliday]]
* [[Custom Defined Holidays]]
* [[Sscalculation]]
* [[Template_/_Type_Formula#Counting_and_Adding_Business_Days|Using Template Formulas to Count and Add Business Days]]
 
[[Category:JavaScript]]
[[Category:validate.js]][[Category:Date Formats]]
8,849
edits

Navigation menu