Tried using the dateMacro fields but that is not working. Any ideas?
racarlton: First of all, did you mean the Start Date OOTB column (schedule_start)? Unless we create a portlet with NSQL, this is the closest I could make it:
Choose the Rolling date range from the List filter fields properties and chose the date from current date until end of the cur qtr. I could not find an option to specify a date, so this might be one option, even though its does not totally give you what you were looking for. I will continue to search for other options.
You may also think of creating a new Calculated attribute something like this
DateDiff(Now(), <the date attribute id you are referencing>,"Day")
and then use the attribute in filter by setting its Display type to be Numeric Range
Let me know if it works for you.
Rodney Carlton, BRMP
BIS Business Relationship Manager – Operations | Cooper Tire & Rubber Company
• 701 Lima Avenue, Findlay, Ohio, 45840
• Office: 419-429-6811 • Cell : 419-348-4742
Create a custom (NSQL based) portlet to produce a list of ideas - with a link off to the idea instance itself.
Your NSQL can then do "any" sort of imaginative filtering that you might want.
Retrieving data ...