Date Calendar Control
Hi All,
I am trying to assign date calendar for Creation Date column. Steps what I have taken are
I used Range(Inclusive) for Creation Date Column in Query Designer.
Deselected the available values from query option in both FromCreationDate and TOCreationDate Parameters. NO Default values were assigned.
I modified the FromCreationDate and TOCreationDate parameter values in the main dataset as
="[OCP Date].[Standard Date].&[" + CStr(Format(Parameters!FromOCPDateStandardDate.Value, "mm/dd/yyyyT00:00:00"))+"]"
="[OCP Date].[Standard Date].&["+ CStr(Format(Parameters!ToOCPDateStandardDate.Value, "mm/dd/yyyyT00:00:00"))+ "]"
However, I am getting the following error message
An Error Occurred during local report processing
An error has occured during local report processing
Query execution failed for dataset 'x'.
The Query (1,875) The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated.
Further, I tried Format(CDate()), yyyy/dd/mmT00:00:00, and removed CONSTRAINED in the main query options but still facing the same error.
This the format I have in CreationDate...[OCP Date].[Standard Date].&[01/01/1989]
Any help would be really I appreciated.
Thanks
Tarak
April 26th, 2011 11:57am