Evaluation time functions - restriction of value to chart

Jeff S
Jeff S used Ask the Experts™
on
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)
Comment
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
Commented:
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]
    1
Else
     2

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

mlmcc
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.

 James

Author

Commented:
Thanks!

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