8,849
edits
Changes
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==
'''Example:'''
var newDate=ConvertDateStr(frm.startdate.value,'@dateformat@');
==ConvertDate==
Takes a date that is in the standard database format of yyyy-mm-dd and converts it to the preferred display format of the current user.
'''Syntax:'''<br>
:<font size="3">'''ConvertDate(''date'','@dateformat@')'''</font>
'''Where:'''
* ''date'' is the date you wish to change to the users preferred display format.
'''Example:'''
var newDate=ConvertDate(sdate,'@dateformat@');
==ssConvertDate==
Takes a date that is in the standard database any date format of yyyy-mm-dd and converts it to the preferred display any other date format of the current user.
'''Syntax:'''<br>
:<font size="3">'''ssConvertDate(''date'','@dateformat@fromdateformat','todateformat')'''</font>
'''Where:'''
* ''date'' is the date you wish to change to the users preferred display format.
* ''fromdateformat'' is the format of the date you are providing
* ''todateformat'' is the format you want the resulting date to use.
'''Example:'''
var newDate=ssConvertDate(sdate,'@dateformat@yyyy-mm-dd','dd/mm/yyyy');or var newDate=ssConvertDate(sdate,'mm/dd/yyyy','dd-mm-yyyy');
::* '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]]