Happy Business Starts Here

Support SME

DateTime "is equal to" not in Reporting filters

In the Reporting engine, datetime fields cannot be filtered by the "is equal to" operator, though date fields still can.

Date field example: Invoice Date
Datetime field example: Invoice Created Date

The Data Sources engine does not have this restriction.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Support SME

Re: DateTime "is equal to" not in Reporting filters

From a historical standpoint, our Data Source Exports did not have this 'restriction'. When we developed the new reporting feature, our reporting team determined that in most use cases it was not beneficial to use an "=" operator with DateTime since the chances of an exact match are very low.

Therefore they did not include this logic in Reporting.

 

As workaround you can still use the "is during a specific date range" for dateTime filters. For example:

 

Date is equal to 3/23/2017
(would be equal to)
DateTime is during a specific date range from 3/23/2017 12am PDT to 3/24/2017 12am PDT

 

Zuora 2017-03-23 at 10.35.30 AM.png

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √