Evaluation time functions - restriction of value to chart

Jeff S
Jeff S used Ask the Experts™
I am unsure how to tell my side by side bar chart to ignore a 01/01/1900 MonthYear value. I tried to create a fomula to ignore anything with a 01/01/1900, however when it layed out my graph it did not lay them out in the months I needed rather it passed a True and False value. How can I pass all dates but these to my chart?

My formula I tried to restrict the values:

Date({data.MonthYear}) <> Date(1900,1,1)
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
You really can't filter a chart that way.

DO you need the records that have 1900-01-01 as the date in the report?

Can you group the report by date so all the 1900-01-01 records are in one group and the rest in another group and get the report you want?

Create a formula
If Date({data.MonthYear}) = Date(1900,1,1)  then]

Add a group on the formula
Put the chart in the group heade or footer.
You can suppress the header/footer when the date is 1900-01-01

To add to what mlmcc said, if you don't need the 01/01/1900 records in the report for some other reason, add Date({data.MonthYear}) <> Date(1900,1,1) to the record selection formula.  Then those records won't be included at all, so they won't be in the chart.




Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial