Customer experience | Sales, Customer Insights,...

How can I resolve the error stating: The date-time format for @activities('Set variable1').value is invalid, or value is outside the supported range.

(0) Share

Report

Posted on by Rushank

I want to filter the source records to pick up only the reords since Maximum Last modified Datetime in SQL. I am using a lookup block to Pick up the maximum date from SQl and stoe it a variable, but while I pass it in source in the form of Fetch XML I receive the error.
My Filter block in FetchXML is as follows:

Is there some other way in which I should pass this in fetch XML or some other Work Around.

My ADf pieline is as follows:

I have the same question (0)

All responses (4)

Answers (0)

Rushank 5 on at

Like (0)

Report

Please help if any solution.

Was this reply helpful? Yes No
v-ancos on at

Like (0)

Report

Dear Rushank ,

We need to understand where this filter is used.

Can you please give us more details?

Regards,

Was this reply helpful? Yes No
Suggested answer

v-ancos on at

Like (0)

Report

Dear Rushank ,

You need to use a Link Entity.

You can see below an example between account and contact.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
  <entity name="account">
    <attribute name="name" />
    <attribute name="primarycontactid" />
    <attribute name="telephone1" />
    <attribute name="accountid" />
    <order attribute="name" descending="false" />
    <link-entity name="contact" from="parentcustomerid" to="accountid" link-type="inner" alias="ab">
      <filter type="and">
        <condition attribute="modifiedon" operator="last-month" />
      </filter>
    </link-entity>
  </entity>
</fetch>

Regards

Was this reply helpful? Yes No
Rushank 5 on at

Like (0)

Report

Hi Ana,

I don't think I require a Link Entity because I am straightforward using the Modifiedon date from Quote Entity. Now Instead on using a variable I am trying to output of Lookup block directly. My Fetch XML with the condition is as follows:

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">

<entity name="quote">

<attribute name="msdyn_estimatedschedule"/>

<attribute name="name"/>

<attribute name="statecode"/>

<attribute name="totalamount"/>

<attribute name="quoteid"/>

<attribute name="createdon"/>

<order descending="false" attribute="msdyn_ordertype"/>

<attribute name="totallineitemamount"/>

<attribute name="msdyn_grossmargin"/>

<attribute name="totalamount_base"/>

<attribute name="totalamountlessfreight"/>

<attribute name="totallineitemdiscountamount"/>

<attribute name="totalamountlessfreight_base"/>

<attribute name="totaldiscountamount"/>

<attribute name="totallineitemamount_base"/>

<attribute name="msdyn_estimatedbudget"/>

<attribute name="quotenumber"/>

<attribute name="modifiedon"/>

<filter type="and">

<condition attribute="modifiedon" operator="on-or-after" value="@activity('Lookup1').output.firstRow.maxDate"/>

</filter>

</entity>

</fetch>

I am still receiving the same Error.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How can I resolve the error stating: The date-time format for @activities('Set variable1').value is invalid, or value is outside the supported range.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How can I resolve the error stating: The date-time format for @activities('Set variable1').value is invalid, or value is outside the supported range.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates