Hi All.
A client is having a very odd problem with fetch block in a map.
Here is scenario - the connection is D365
Fetch appointments where owner = x and actualclosedate > yesterday -1day and actualclosedate < yesterday +1 day (trying to generate a report that pulls all appointments closed on yesterday. When I look at debug, the queries all look right, yet the fetch only returns 1 record when there are actually 4 in D365
An advanced find in D365 for appointments where owner = x and actualclosedate = yesterday yields 4 records as it should.
Anyone have any similar issues Apparently using the formula of actualclosedate = yesterday doesnt work, hence the greater than and less than
Seems like no matter what formula we use the result of the fetch is not accurate.
Any help would be appreciated.
Thanks
Don