Setting an "as of date" variable using a Calendar Object

[#1]

I'm trying to setup an "as of date" variable. The calendar object based on the "as of date" variable is not relating correctly to the charts. The chart is displaying "no data to display" when there is in fact plenty of data. I've used both "set analysis" and "if statements" in my chart expressions without luck. Any thoughts?

[deepakk]

hi,

It might be possible the value in your Asondate might be in nummeric format and you might be comparing it with Date format.

eg:

if(Date <AsOnDate, Value)

if(01/01/2010 < 4009, Value)

soln : try creating a datenum in script level and compare it with asondate.

[#3]

I have tried using both datenum and date but it still won't work. Also, I have used the date function in my expressions to ensure that my data is in the same format but it isn't fixed.

[deepakk]

HI,

Its always become little tricky if your playing with Date field. Can you post some Data or the application so that we can test it our end.

[#5]

Hey thanks for your help, but I figured it out. For some reason when I changed the min and max value in my calendar everything was fine. Thanks again!