# Why is the Delta date field mandatory in Salesforce Delta Export?

**URL:** <https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176>\
**Category:** Integrator.io\
**Tags:** salesforce\
**Created:** [April 2, 2026, 12:48pm UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176 "2026-04-02T12:48:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Varun\_Thangaraj](https://avatars.discourse-cdn.com/v4/letter/v/e19adc/32.png) [@Varun\_Thangaraj](https://connective.celigo.com/u/Varun_Thangaraj)\
**Post date:** [April 2, 2026, 12:48pm UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176/1 "2026-04-02T12:48:35Z")

</div>

Hi ,

I’m trying to use Delta Export on Salesforce. But i don’t want to use the dropdown selection and want to provide custom export query using export time.

I have followed the method mentioned in post : [Override Automatic Filter on a Delta Export?](https://connective.celigo.com/t/override-automatic-filter-on-a-delta-export/154)

But, the Date Fields to use in Delta search is mandatory and i’m not able to save.

is this expected or i’m doing something wrong.

```sql
select Id
from Object where 
and (Parent_Object.LastModifiedDate <= {{data.currentExportDateTime}} or Object <= {{data.currentExportDateTime}})

```

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b41896b14828c6d148c2453b5510475a8a755f47.png)

can anyone help me on this?

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [April 2, 2026, 2:42pm UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176/2 "2026-04-02T14:42:35Z")

</div>

You have to use `{{data.lastExportDateTime}}` somewhere

---

<div class="post-metadata">

**Author:** ![Varun\_Thangaraj](https://avatars.discourse-cdn.com/v4/letter/v/e19adc/32.png) [@Varun\_Thangaraj](https://connective.celigo.com/u/Varun_Thangaraj)\
**Post date:** [April 3, 2026, 4:09am UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176/3 "2026-04-03T04:09:04Z")

</div>

@tylerlamparter , Thanks for the hint. It worked

I do have a question. I noticed all i had to do was to add {{data.lastExportDateTime}} in comment in the query section and the required condition removed on Delta field. It seems unnecessary to have such restriction that {{data.lastExportDateTime}} has to be present in data export

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/97d170f721bcf401c32508d6a5adac61e065c61e.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [April 3, 2026, 12:53pm UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176/4 "2026-04-03T12:53:42Z")

</div>

Hey Varun, this is good feedback for the #Product Feedback channel. Probably for 99% of the time, users only need the multi-select drop down of dates, but we could think of something better here for both those users and power users.

---

<div class="post-metadata">

**Author:** ![friendoftuesday](https://avatars.discourse-cdn.com/v4/letter/f/c89c15/32.png) [@friendoftuesday](https://connective.celigo.com/u/friendoftuesday)\
**Post date:** [April 3, 2026, 2:47pm UTC](https://connective.celigo.com/t/why-is-the-delta-date-field-mandatory-in-salesforce-delta-export/6176/5 "2026-04-03T14:47:02Z")

</div>

I've had similar situation in an HTTP lookup once; I just threw the data.lastExportDateTime in an fake URL parameter (e.g., `/path?this=that&ignore={{data.lastExportDateTime}}`)