Monday 2 September 2013

Job for Date time difference


static void DateDiffInHours(Args _args)
{
    ActivationDateTime ActivationDateTime;
    ACWAPIPEServiceRequestTable ACWAPIPEServiceRequestTableFrom,ACWAPIPEServiceRequestTableTo;
    int HourVal,TimeVal;
    str HourwithTime;
    int64 sdjfsh;
   // FromTime 5637144578
    //Totime   5637144835
    select ACWAPIPEServiceRequestTableFrom where ACWAPIPEServiceRequestTableFrom.RecId == 5637144835;
    select ACWAPIPEServiceRequestTableTo where ACWAPIPEServiceRequestTableTo.RecId == 5637146080;
    //sdjfsh = DateTimeUtil::getDifference(ACWAPIPEServiceRequestTableTo.createdDateTime,ACWAPIPEServiceRequestTableFrom.createdDateTime)/60;
    sdjfsh = DateTimeUtil::getDifference(ACWAPIPEServiceRequestTableTo.createdDateTime,ACWAPIPEServiceRequestTableFrom.createdDateTime);
    info(strFmt("%1",sdjfsh));
    HourVal = int642int(sdjfsh/60);
    TimeVal = sdjfsh - (HourVal*60);
    HourwithTime = int2str(HourVal) + ":" + int2str(TimeVal);
    info(strFmt("%1",HourwithTime));
    info(strFmt("%1",HourVal*60));
 
}


No comments:

Post a Comment