4 Replies Latest reply: Feb 24, 2010 12:39 PM by Rakesh Boorgu RSS

    Problem with condition in expression.

    Rakesh Boorgu

      Hi guys,

      I came across, something which looks a wierd behavior to me.

      I have a chart, where in, the expression should have a condition.

      So i have a variable created (in the variable overivew) which evaluates the recent most Friday.

      its calculated as '=weekend(today(),-1,-2)'. which works fine when tested.

       

      But in the expression, if i place the condition as if(theDate = RecentFriday,'then do this'), it doesn't work.

      instead if I do if(theDate = '2/19/2010','then do this'). it works fine.

      and i checked the value of the RecentFriday.... it shows 2/19/2010.

       

      Any help would be greatly appreciated.

       

      Thanks,

      Rocky