filter data range with datepicker (german date format)
I try to filer a data range with two datepickers with the following date format: dd.mm.yyyy
I can't find a way to filter the records in the MySQL database correctly. Where do I have to reformat the date from dd.mm.yyy to yyyy-mm-dd?
The fields look like this:
<input id="DatumVon" name="DatumVon" type="text" value="<?php echo((isset($_GET["DatumVon"])?$_GET["DatumVon"]:"")); ?>" class="formTextfield_Medium" tabindex="2" onBlur="hideServerError('fieldset_group_ServerError_2');" placeholder="<?php echo $today; ?>">
<input id="DatumBis" name="DatumBis" type="text" value="<?php echo((isset($_GET["DatumBis"])?$_GET["DatumBis"]:"")); ?>" class="formTextfield_Medium" tabindex="3" onBlur="hideServerError('fieldset_group_ServerError_2');" placeholder="<?php echo $dayInOneWeek; ?>">
DB-Select is:
SELECT *
FROM res_datum
WHERE Datum BETWEEN param1 AND param2
ORDER BY Datum ASC
param1 is DatumVon
param2 is DatumBis
Thanks for any help?