Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need to create a report filter that compares an integer field with the year of a date field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to create a report filter that compares an integer field with the year of a date field

Accepted answer
20
Views
8
Comments
edited May 22, 2019 5:38PM in Reporting & Analytics for B2C Service 8 comments

Summary

Need to create a report filter that compares an integer field with the year of a date field

Content

Hey Team,

I need to create a report filter that compares an integer field with the year of a date field. E.g. if the Integer field has value 2018 and if we compare to the system time/date current year (2019) and if the value is lower then we need to display in column. 

Is there any standard way to achieve this?

Regards, Vikash

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!