09-23-2024 11:17 AM
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
Solved! Go to Solution.
10-23-2024 09:03 PM
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
10-23-2024 09:03 PM
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