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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics