I have a field in one of my Universe tables, (SF_Opportunity) called CloseDate. The field has a datetime definition and the data displays as 10/16/2009 12:00:00 AM. I want to create a condition on the SF_Opportunity table in my Universe which will allow me to easily query (in WebI) only those SF_Opportunity records which have a CloseDate within the current month.
I'm very new to Universe Designer and I've found no documentation which explains how to accomplish this.
Could anyone provide an example of how I do this?
Many thanks...