MySQL's default DATE field format is "YYYY-MM-DD".
But in my one of the MYSQL DB Table (in which Data is coming from other service) Date is stored in Format "DD/MM/YYYY"
i.e., 24/03/2014
which creates problem when I Filter the data of that Table using DATE filter in My Web page.
There is a web page in which a Textbox , Button , and Grid is there.
When I choose Data in Textbox(using ajax calander) and click on button, related DATE data should show in Grid.
Since the Date format is not correct in DB table, it do not filter any data.
HTML code:
<asp:TextBox ID="TFDate" runat="server" Width="40%"></asp:TextBox>
<cc1:CalendarExtender ID="CalendarExtender1" runat="server" Enabled="True" Format="dd-MM-yyyy" TargetControlID="TFDate"></cc1:CalendarExtender>
<asp:Button ID="Bshow" runat="Server" Text="Show Report" OnClick="Bshow_Click1"/>
//Also, Gridview
Please suggest some way how to solve this problem while doing DATE filter. Because I can not change the date format which is coming in DB Table.
Please reply.