DEVELOPERS FORUM - How to compare datetime use javascript

rootkiter - Tuesday, November 23, 2010 9:15 PM:

Help me find the item that have property datetime before (or after) the fix datetime

Ex:

Itemtype A have property arriveday type datetime

I want to find all item A that has arriveday > 2/2/2010

raviraj - Monday, November 29, 2010 5:50 AM:

Hello rootkiter

U can Use like this....

var todate = new Date(todatestring);
var fromdate = new Date(fromdatestring);

if (todate < fromdate)
{ 
alert('Error');//  that will be  your code....
}

rootkiter - Tuesday, December 7, 2010 1:45 AM:

Thank Raviraj, but i mean that i need the way to find item that have property date, and    fixdate1 <= date <= fixdate2

Ex:

   // To find_itemValues that have date >= fixdate1
    _itemValues.setProperty("date", fixdate1);
    _itemValues.setPropertyAttribute("date", "condition", "gt");
    _itemValues = _itemValues.apply();   
   

Or

   // To find_itemValues that have date <= fixdate2
    _itemValues.setProperty("date", fixdate2);
    _itemValues.setPropertyAttribute("date", "condition", "lt");
    _itemValues = _itemValues.apply();   

I want to find _itemValues that have date between fixdate1 and fixdate2. Some one help me plz

Ronan - Tuesday, December 7, 2010 11:11 AM:

Hi,

If I understand correctly, what you want are the newAND() and newOR() methods. Example:

var myItem = myInnovator.newItem('Foo','get');
var logicalAND = myItem.newAND();
logicalAND.setProperty('foo','bar1');
var nestedOR = logicalAND.newOR();
nestedOR.setProperty('foo2','bar2');
nestedOR.setProperty('foo3','bar3');
//The following line of code is optional because 'eq' is the default property condition:
logicalOR.setPropertyCondition('foo3', 'eq');


rootkiter - Wednesday, December 8, 2010 2:21 AM:

Thank Ronan,

I have try your way already, but nothing happen, no error, no result   :(.

rootkiter - Wednesday, December 8, 2010 3:11 AM:

Finally, i found the way, try

.setAttribute("where","condition");

Thank all of you