Date fields in a Epicor BAQ

[johnw]

I have a date field in a BAQ in epcior so when I search on it in Workato it looks like this

Part sfdc child update c: 2024-08-22T10:39:35.827000-04:00,

when I try and filter on that date field it doesn't seem to work 

I've tried Greater than 

3.days.ago

tried

today - 3 days

seems like it should be simple and it probably is 

[julie-reyes · Accepted solution]

Hi,

Good day!

To filter date fields, you can utilize the various date formulas that are indicated in our documentation. It is important to ensure that the format of the date field you are trying to filter is the same as the format used in the formula. This will ensure that the filtering is done correctly.

Additionally, we recommend referring to the Epicor BAQ API documentation for guidance on how to properly filter date fields using their API. This will provide you with specific instructions and examples to help you with your filtering needs.

If you require further assistance with this, please do not hesitate to open a ticket in our Support portal. Our team of experts will be more than happy to assist you and provide any additional guidance you may need.

Thank you