I have a chart that I’m trying to drill down to another chart based on a date column. The date is passed in a httpParameter “Date” and when I try to consume that date in a CAML filter in the drilled down chart the date is in the wrong format so it doesn’t return any results (the chart works when I put in a fixed value but won’t work when grabbing the httpParameter value). The date that is passed in the httpParameter looks like “5/27/2011” and the date it wants is “2011-05-27T00:00:00Z” (based on the fixed value).
Any ideas how to get the CAML filter to work based on a date passed in from another charts date value through a httpParemeter?
Viewing 0 reply threads
You must be logged in to reply to this topic.
Thank You! We will send you the white paper shortly.