Evaluation Time Functions - not sure how I can get results as I need.

[SBSMedicalTech]

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?

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

 

[hilfy]

Try this:

If Date({data.MonthYear}) <> Date(1900,1,1) then {date.MonthYear}

This will return null when the date is 1/1/1900, so the data should not appear on the chart.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.