Changes

Jump to: navigation, search

Manipulating Dates

1,730 bytes added, 16:34, 16 August 2010
no edit summary
==ConvertDateStr==
Takes a date that is in the users preferred display format and returns the date in the standard database format of yyyy-mm-dd.
 
'''Syntax:'''<br>
:<font size="3">'''ConvertDateStr(''date'','@dateformat@')'''</font> '''Where:'''* ''date'' is the date you wish to change to the ''yyyy-mm-dd' format.
'''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@');
==Notes==
* When populating a date field that is displayed on the page it must be added in the preferred date format of the current user, as the system will automatically change it to yyyy-mm-dd when the page is saved.
 
 
==dateadd==
Add the specified interval to a date
 
'''Syntax:'''<br>
:<font size="3">'''dateadd(''date'',''unit'',''interval'')'''</font>
 
'''Where:'''
* ''date'' is the date you wish to add to (or delete from) in format yyyy-mm-dd
* ''unit'' specifies what is being added:
::* 'd' (days)
::* 'm' (months)
::* 'y' (years)
* ''interval'' is the number of days/months/years to be added.
 
'''Example:'''
var newDate=ConvertDate(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.
<pre>
var sdate=ConvertDateStr(frm.startdate.value,'@dateformat@');
var duration=parseInt(parseFloat(frm.cf_123456.value));
if(isNaN(duration)){
alert("Invalid Duration provided");
return;
}
var edate=dateadd(sdate,'m',duration);
frm.enddate.value=ConvertDate(edate,"@dateformat@");
</pre>
[[Category:JavaScript]]
0
edits

Navigation menu