Parameter field for date is not working

Question

I created crystal report and i created one parameter field for column date_of_birth field.it is date

data type in sql server.it is stored as yyyy-mm-dd. 2015-09-26.

 

After creating the parameter the records are filtering and showing according to dates in preview of crystal report.it is showing all records.

 

So please tell what is steps for creating date parameter in crystal report.

Answer 1

Thanks.

 

But I don't have fixed Max & min date.

So, I write a code in Textchanged event & in that I'm checking the Textbox date with Max & min date.

If textbox date is between the range of min & max date then its ok else gives Errormessage.

Answer 2

Hi Just try below mentioned code.

 

<asp:TextBox ID="txtDate" runat="server" ReadOnly = "true"></asp:TextBox>

<br />

<asp:RangeValidator runat="server" ID="RangeValidator1" Type="Date" ControlToValidate="txtDate" MaximumValue='09/20/2011' MinimumValue="09/01/2011"

ErrorMessage="Date should be between 09/01/2011 and 09/20/2011" Display="Dynamic" />