Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 Fetch XML Expressions RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I have a fetch xml query and I would like to filter records with a date & time field.

    I use the expression on or before but this seems to filter only date (without time).  

    ....

    '<attribute name="scheduledend" />'+
    '<filter type="and">'+
    '<filter type="or">'+
    '<condition attribute="scheduledend" value="'+ currentdate +'" operator="on-or-before"/>'+
    '<condition attribute="scheduledend" operator="null"/>'+
    '</filter>'+
    '</filter>'+

    .....

    Thanks in advanced!

    Thursday, March 14, 2013 1:41 PM

All replies