A date-time is required here warning. 1

[SBSMedicalTech]

I am getting the following message on my formula: "A date-time is required here."

{data.MonthYear} <> '01/01/1900'

I am trying to create a formula to exclude transactions with a MonthYear = 01/01/1900 in a side by side bar chart. Any help is appreciated.

 

[crystalkiwibruce]

replace the formula with
{data.MonthYear} <> Date(1900,1,1)// y,m,d

Quotes indicate a string value, not a date. Need to use the function above.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm