dynamics crm 2011 - FetchXML - Today - minus 30 days -

dynamics crm 2011 - FetchXML - Today - minus 30 days -

i attempting create fetchxml script retrieves records date of today minus 30 days.

below sql works. help me fetchxml, please?

select * [students] start_date = convert(date,dateadd(day,-30,getdate()))

thanks in advance,

richard

fetchxml provides limited back upwards specific problem.

you have calculate target date , pass filter value:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="account"> <attribute name="name" /> <filter type="and"> <condition attribute="createdon" operator="on" value="2015-03-13" /> </filter> </entity> </fetch>

if didn't try: utilize advanced find explore built-in filters supported datetime attributes via downloading generated fetchxml.

dynamics-crm-2011 dynamics-crm microsoft-dynamics fetchxml