# Workday WQL Error

**URL:** <https://community.cdata.com/t/workday-wql-error/582>\
**Category:** CData Sync\
**Tags:** question, workday, wql, cdata-sync\
**Created:** [December 22, 2023, 5:42pm UTC](https://community.cdata.com/t/workday-wql-error/582 "2023-12-22T17:42:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshphillipssr](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@joshphillipssr](https://community.cdata.com/u/joshphillipssr)\
**Post date:** [December 22, 2023, 5:42pm UTC](https://community.cdata.com/t/workday-wql-error/582/1 "2023-12-22T17:42:06Z")

</div>

Using CData Sync Cross Platform with Workday WQL connection. Some queries work successfully, but a bunch fail with this message:

[0] Received error from Workday: Invalid WQL query: !\*\*! This error occurred during a request to calculate the field !\*\*!, for instance !\*\*!.. Cause: com.workday.exceptions.ExternalFieldException: The Increment or Decrement Date field, !\*\*!, has encountered a blank date..

 ![ef450771-fc42-478b-9283-017cfadce5ab.png](https://us1.discourse-cdn.com/cdata/original/1X/dc9c949b9a92efcdb641b92d76068e665d6a6204.png)

Thanks.

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [December 22, 2023, 9:21pm UTC](https://community.cdata.com/t/workday-wql-error/582/2 "2023-12-22T21:21:04Z")

</div>

Hi @joshphillipssr

I am not immediately sure what exactly is causing the error for you, however I know that we have had other users report that the inclusion of certain columns in the allworkers object has caused similar issues for them in the past.

That being said, you may find setting the connection property MetadataFilters to ‘Calculated’ helpful (MetadataFilters=Calculated). This setting will automatically filter out all of the calculated fields and should eliminate these kind of issues. You can read more&nbsp;here:

> **[CData JDBC Driver for Workday - MetadataFilters](https://cdn.cdata.com/help/JWJ/jdbc/RSBWorkday_p_MetadataFilters.htm)**
>
> CData JDBC Driver for Workday - RSBWorkday - MetadataFilters: Specifies what types of fields are ignored by the provider.

In case the above suggestion does not work for you and&nbsp;you keep facing this error, there might be a need to take a look at the job logs for further investigation so it would be better to reach out to our support team at [support@cdata.com](mailto:support@cdata.com) or submit a ticket with support here: [https://www.cdata.com/support/submit.aspx](https://www.cdata.com/support/submit.aspx).