generator-date , -date-calculate dateCalculate -default dtoc from date to date

_refreshv2('RECEIPT_HEADER.DATE',_today());


from date to date


{object}
0.30,query.GRN_SN_EXP,date,10,10,From D. Expire: Date ,,
{toolTips}Distributor Expire Date{/toolTips}
{from}
{placeHolder}yyyy-mm-dd{/placeHolder}
{default}empty{/default}
{colspan}3{/colspan}
{/object}


{object}
0.30,query.GRN_SN_EXP{to},date,10,10,To : Date ,,
{default}_today('y5'){/default}
{to}
{dependent}
{/object}

* and it depend on config file.

date layout

{object}
0.12,PURCHASE_HEADER.DATE,date,12,12,Date,,
{default}today{/default}
{default}_today(){/default}
{default}_today('now'){/default} /*last date of last month*/
{default}_today('lol'){/default} /*last date of last month*/
{default}_today('fol'){/default} /*first date of last month*/
{default}_today('fom'){/default} /*first date of this month*/
{default}_today('d5'){/default} /*last 5 date*/
{default}_today('D5'){/default} /*next 5 date*/
{default}_today('y5'){/default} /* next 5 years */
{placeHolder}yyyy-mm-dd{/placeHolder}
{default}empty{/default}
{required}
{string}.substring(2,10){/string}
{inLineStyle}direction:rtl;{/inLineStyle}
format YYYY-MM-DD TO YY-MM-DD
{/object}



date difference
{onchange}
var d1 = new Date(this.value);
var d2 = new Date(userStrVariable0);
if(d2>d1){alert('New DNOte Date '+this.value+'cannot < the Old DNote Date '+userStrVariable0+' !!');this.value='';}
{/onchange}

date difference

{object}
1.361,DNOTE_LINE.EXPIRE_DATE,date:GRID,8%,150,Expire Date,,
{labelInLineStyle}font-style: italic;{/labelInLineStyle}
{tooltip}Maintenance Expire Date{/tooltip}
{onchange}
var sDateFrom=_lookup('DNOTE_LINE.ACTIVE_DATE'+thisRowNo);
var sDateTo=_lookup('DNOTE_LINE.EXPIRE_DATE'+thisRowNo);
var d1=parseDate(sDateFrom);
var d2=parseDate(sDateTo);
alert(DateDiff.inMonths(d1, d2));
/*e.g. DateDiff.inDays(d1, d2),DateDiff.inWeeks(d1, d2),DateDiff.inMonths(d1, d2),DateDiff.inYears(d1, d2)*/

{/onchange}

{/object}




_today()

function _today(){
var _today;
dateValue = new Date()
var M = "" + (dateValue.getMonth()+1);
var MM = "0" + M;
MM = MM.substring(MM.length-2, MM.length);
var D = "" + (dateValue.getDate());
var DD = "0" + D;
DD = DD.substring(DD.length-2, DD.length);
var YYYY = "" + (dateValue.getFullYear());
_today=YYYY+'-'+MM+'-'+DD;
return _today}
e.g.

{default}empty{/default}

{-----------------copy this code--------------------------------}


{refresh}
var s0723=_lookup('SALES_HEADER.INV_DATE');
if (s0723){
var oBeijing =parseDate(s0723);
var s0723a='10';
var oMyDate = dateCal(oBeijing,s0723a);
s0723=dtos(oMyDate,'yyyy-mm-dd');
if(s0723!='1899-12-31'){
_refreshv2('SALES_HEADER.DUE_DATE',s0723);}
}
{/refresh}

{-------------------------------------Lead Time --------------------------------------------------------}
{object}
0.679,SALES_ORDER_HEAD.LEADTIME,int,5,3,Committed Lead Time (Day),,
{numeric}
{alignRight}
{refresh}
var s0723=_lookup('SALES_ORDER_HEAD.ENTRY_DATE');
if (s0723){
/*var oBeijing = new Date(s0723);*/
var oBeijing =parseDate(s0723);
var s0723a=_lookup('SALES_ORDER_HEAD.LEADTIME');
var oMyDate = dateCal(oBeijing,s0723a);
s0723=dtos(oMyDate,'yyyy-mm-dd');
if(s0723!='1899-12-31'){
_refreshv2('SALES_ORDER_HEAD.REQUEST_SHIP_DATE',s0723);}
}
{/refresh}
{enableAutocomplete}
{tooltip}Please Input days.  (Calender day){/tooltip}
{/object}

{object}
0.67,SALES_ORDER_HEAD.ENTRY_DATE,date,9,10,Customer Order Rec. Date,,
{submitMust}
{default}{/default}
{tooltip}Customer Order Received Date{/tooltip}
{placeHolder}yyyy-mm-dd{/placeHolder}
{refresh}
var d1 = new Date(_lookup('this..CUSTOMER_PO_DATE'));
var d1add= dateCal(d1,4);
var d2 = new Date(_lookup('this.id'));
if (d2>d1add){$('.SALES_ORDER_HEAD_ENTRY_DATE').css('color', 'red');} else {$('.SALES_ORDER_HEAD_ENTRY_DATE').css('color', 'black');};
{/refresh}
{/object}



{object}
0.67,SALES_ORDER_HEAD.COMMITTED_COMPLETION_DATE,date,10,10,Actual Completion Date,,
{default}empty{/default}
{placeHolder}yyyy-mm-dd{/placeHolder}
{/object}


{default}  /  /  {/default}
{default}{/default} <- default today