I have created a dataview in SP Designer 2007. The dataview is driven by a date filter (only show data up to the date selected by the user) which uses a parameter. The parameter is getting it's value from the DateTimeControl. Everything works fine except
in order for this to work I have to use the following format (2011-05-19) for the DateTimeControl because SharePoint stores it's dates in ISO format. I have tried converting the format using a calculated column on the list, but that will only return the format
(5/19/2011) as a text value which I can't filter on.
Does anyone know of a way to use the 5/19/2011 format in the DateTimeControl and still get the date filter to work?
View Complete Post