Date fields in a Epicor BAQ

johnw — Mon, 23 Sep 2024 18:17:47 GMT

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

Re: Date fields in a Epicor BAQ

julie-reyes — Thu, 24 Oct 2024 04:03:42 GMT

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

topic Date fields in a Epicor BAQ in Workato Pros Discussion Board

Date fields in a Epicor BAQ

Re: Date fields in a Epicor BAQ