Can you give me the syntax to retrieve the year from a date field? I tried to use the javascript object getFullYear() but because of the formatting of the date fields, it seems to return a null value. script type="text/javascript" var d = '{!award_date}'; var n = d.getFullYear(); return n; /script (removed the so the script will show) 001 function wrapper() { 002 007 } 008 wrapper(); Formula return type: Integer Result null
001 function wrapper() {
002 script type="text/javascript"
003 var d = 'Fri Feb 24 2012';
004 var n = d.getFullYear();
005 return n;
006 /script
007 }
008 wrapper();
Formula return type: Integer
Result
null
var d = 'Fri Feb 24 2012'; - this is String.
Try this:
var d = new Date('Fri Feb 24 2012');
You can find this example in documentation (Chapter 6)
Hi,
Try this
var d = new Date('{!award_date}');
var n = d.getFullYear();
return Number(n);
Return type: integer