Date reformat in coupon, product insert

Hi,

I my quest to ozzify PS4 can I change the date format display on the insert page of coupons and products insert.

The code below is the coupon insert start date. line 175

<input id="CouponStartDate" name="CouponStartDate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("couponsInsert","CouponStartDate"):"")); ?>" class="formTextfield_Medium" tabindex="7" onblur="hideServerError('CouponStartDate_ServerError'); return false;"/>

Regards

Russ

ps, it displays as mm,dd,YY
I would like the display as dd,mm,YY

in the admin/scripts/coupons_insert.js file


change:

$(function(){
	$('#CouponStartDate').datepicker({
		changeMonth: true,
		changeYear: true,
		onClose: closeDatePicker_CouponStartDate
	});
});

to:

$(function(){
	$('#CouponStartDate').datepicker({
		changeMonth: true,
		changeYear: true,
		dateFormat: 'dd/mm/yy',
		onClose: closeDatePicker_CouponStartDate
	});
});

and change:

$(function(){
	$('#CouponEndDate').datepicker({
		changeMonth: true,
		changeYear: true,
		onClose: closeDatePicker_CouponEndDate
	});
});

to:

$(function(){
	$('#CouponEndDate').datepicker({
		changeMonth: true,
		changeYear: true,
                dateFormat: 'dd/mm/yy',
		onClose: closeDatePicker_CouponEndDate
	});
});

on the coupon_insert.php page you will also need to change:

var CouponStartDate_Spry = new Spry.Widget.ValidationTextField("CouponStartDate_Spry", "date", {format:"mm/dd/yyyy", validateOn:["blur"]});
var CouponEndDate_Spry = new Spry.Widget.ValidationTextField("CouponEndDate_Spry", "date", { format:'mm/dd/yyyy' , validateOn:["blur"]});

to:

var CouponStartDate_Spry = new Spry.Widget.ValidationTextField("CouponStartDate_Spry", "date", {format:"dd/mm/yyyy", validateOn:["blur"]});
var CouponEndDate_Spry = new Spry.Widget.ValidationTextField("CouponEndDate_Spry", "date", { format:'dd/mm/yyyy' , validateOn:["blur"]});

Hi, In PS3, I wish to do the same in the users_Search file. I wish to enter dd/mm/yyyy
How is this achieved. Thanks

I'm not sure i understand, the PS3 users search page already allows you to enter the date in that format and will automatically convert it to the format needed by the database.

Hi Jason,
Maybe I have done something wrong...it is not working for me. The Spry format was originally yyyy-mm-dd. I changed this to dd/mm/yyyy
Then I enter 10/03/2011 (10th March). On blur the field gets converted to 03-10-2011 and I get the error 'invalid format'

dont change the spry validation, you should change the client validation to aloow for your date format.


change:

<input class="dateRange" name="S_UserRegistrationDate" type="text" id="S_UserRegistrationDate" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate,'- Invalid date or time',true,/.*/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate,0,true)" value="<?php echo((isset($_GET["S_UserRegistrationDate"]))?$_GET["S_UserRegistrationDate"]:"") ?>" size="15" />

          </span> to <span id="sprytextfield3">

            <input class="dateRange" type="text" name="S_UserRegistrationDate2" id="S_UserRegistrationDate2" value="<?php echo((isset($_GET["S_UserRegistrationDate2"]))?$_GET["S_UserRegistrationDate2"]:"") ?>" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate2,'- Invalid date or time',true,/.*/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate2,0,true)" size="15" />

to:

<input class="dateRange" name="S_UserRegistrationDate" type="text" id="S_UserRegistrationDate" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate,'- Invalid date or time',true,/\b([12]\d|3[0-1]|0?[1-9])\/(1[0-2]|0?[1-9])\/\d{4}\b/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate,0,true)" value="<?php echo((isset($_GET["S_UserRegistrationDate"]))?$_GET["S_UserRegistrationDate"]:"") ?>" size="15" />

          </span> to <span id="sprytextfield3">

            <input class="dateRange" type="text" name="S_UserRegistrationDate2" id="S_UserRegistrationDate2" value="<?php echo((isset($_GET["S_UserRegistrationDate2"]))?$_GET["S_UserRegistrationDate2"]:"") ?>" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate2,'- Invalid date or time',true,/\b([12]\d|3[0-1]|0?[1-9])\/(1[0-2]|0?[1-9])\/\d{4}\b/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate2,0,true)" size="15" />

I changed the code, but still get an error on submit. I entered 10/03/2011 in both fields - see attached

you need to change the pry validation back to the original code and only make changes to the client validation.

Hi Jason, I had already done that. The spry format is yyyy-mm-dd
I modified by using your code above.
I enter 10/03/2011 - the server code (on blur) converts this to 2011-03-10
On submit I get the error below. It occurs even if I leave the 2nd field blank.
This is my code
<label for="S_UserRegistrationDate">Registration Date:</label>
<span id="sprytextfield2">
<span id="sprytextfield2">
<input class="dateRange" name="S_UserRegistrationDate" type="text" id="S_UserRegistrationDate" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate,'- Invalid date or time',true,/\b([12]\d|3[0-1]|0?[1-9])\/(1[0-2]|0?[1-9])\/\d{4}\b/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate,0,true)" value="<?php echo((isset($_GET["S_UserRegistrationDate"]))?$_GET["S_UserRegistrationDate"]:"") ?>" size="15" />
</span> to <span id="sprytextfield3">
<input class="dateRange" type="text" name="S_UserRegistrationDate2" id="S_UserRegistrationDate2" value="<?php echo((isset($_GET["S_UserRegistrationDate2"]))?$_GET["S_UserRegistrationDate2"]:"") ?>" onblur="if (document.getElementById('S_UserRegistrationDateServerValidation')) document.getElementById('S_UserRegistrationDateServerValidation').style.display='none';WAValidateDT(document.forms[0].S_UserRegistrationDate2,'- Invalid date or time',true,/\b([12]\d|3[0-1]|0?[1-9])\/(1[0-2]|0?[1-9])\/\d{4}\b/,'yyyy-mm-dd','','',false,/.*/,'','','',document.forms[0].S_UserRegistrationDate2,0,true)" size="15" />
<span class="textfieldInvalidFormatMsg">Invalid format.</span></span><span id="additionalErrorZone" class="additionalErrorZone"><span class="textfieldRequiredMsg textfieldInvalidFormatMsg textfieldMinCharsMsg textfieldMaxCharsMsg textfieldMinValueMsg textfieldMaxValueMsg">Please enter a valid date, or leave these fields blank.</span></span>
<?php
if (ValidatedField("usersResults","usersResults")) {
if ((strpos((",".ValidatedField("usersResults","usersResults").","), "," . "2" . ",") !== false || "2" == "") || (strpos((",".ValidatedField("usersResults","usersResults").","), "," . "3" . ",") !== false || "3" == "")) {
if (!(false)) {
?>
<span class="textfieldServerError" id="S_UserRegistrationDateServerValidation">Please enter a valid date, or leave these fields blank.</span>
<?php //WAFV_Conditional users_Results.php usersResults(2,3:)
}
}
}?>

This is the Spry:
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "integer", {validateOn:["blur"], isRequired:false});
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "date", {format:"yyyy/mm/dd", isRequired:false, additionalError:"additionalErrorZone"});
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "date", {format:"yyyy/mm/dd", isRequired:false, additionalError:"additionalErrorZone"});

Thanks