CAML Filter based on date HttpParameter

[Anonymous]

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?

[Author]

Posts