To get time difference in Dynamic AX

Hi,

DateTimeUtil::getDifference(DateTimeUtil::getSystemDateTime(), AnotherDateTime)
//Here time components of both the fields are taken out and its difference is being calculated.

Regards,

Container and unbounded string (text) fields are not allowed in a WHERE expression in AX.

Hi,

public void init()
{
    str 30             TimeSheetID;
    DNTimeSheet     LocTimeSheet;
    ;
    super();
    // Check for passed arguments
    if( element.args() )
    {
        // get string parameter
        TimeSheetID = element.args().parm();
        select DNTimeSheet where DNTimeSheet.TimeSheetNum == TimeSheetID;
        ProjectIDFeild.text(ProjID);
        info(strFmt(ProjID));
    }
}

Here TimeSheetID thrown this error.
Solution is  just I declared Str 30 TimSheetID instead of Str TimeSheetID

Regards,