Trying to do date field greater than a specified date in condition editor

[Former Member]

Hi All,

I am trying to build the XML predicate in the expression editor to check that the posting date sent is greater than a specified date to determine the reciever. I can get it to validate posting date is = to specified date, but when I change the = to > it fails to properly determine the receiver, when I send a valid document.

Below is the expression build

(/p1:ServiceAcknowledgementConfirmation/ServiceAcknowledgement[CreationDateTime>'2007-02-03'] EX )

has anyone done this type of check. I have it set as a date type for the expression.

Regards,

Chris

[Former Member]

>=

[Former Member]

Hey all,

I tried >= 2007-02-04 and sent in that exact date. It failed. I removed > so that it is just = 2007-02-04 and it was successful. So, is >= an allowable operator?

Thanks,

Chris

[prabhu_s2]

i had a similar issue in sender jdbc query. but i got it resolved thru this so thought it will work for condition editor also. the other way is to set interval and check it....like >(date) and <= (date)/< (Date)....check the combinations of it. hope this shdu work

[Former Member]

Unfortunately, this does not work either. It is really strange.

Chris

[prabhu_s2]

try for >=