Hi All,
In record producer we have one variable which is Date type, in employee center it is displaying as YY-MM-DD
I have requirement to change this from YY-MM-DD to DD-MM-YYYY in employee center form view and on the request information on the record should show in DD-MM-YYYY format.
I created script include and on change client script.
Script include.
var ValidfromCreateaNewCostCenter = Class.create();
ValidfromCreateaNewCostCenter.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
convertDateFormat: function() {
gs.log('Pu date1');
var incomingDate = this.getParameter('sysparm_format');
var format = 'yyyy/dd/MM';
var gdt = new GlideDateTime();
gdt.setDisplayValue(incomingDate, format);
var gd = new GlideDate();
gd.setValue(gdt.getDate());
return gd.getByFormat("MM/dd/yyyy");
},
type: 'MyConversion'
});
On change Client Script on variable
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
alert('new value ' + newValue);
var ga = new GlideAjax('x_bcb_mdm.ValidfromCreateaNewCostCenter');
ga.addParam('sysparm_name', 'convertDateFormat');
ga.addParam('sysparm_format', 'newValue');
ga.getXMLAnswer(function(response){
alert('gp ' + response);
var FormattedDate = response;
g_form.setValue('variable_name', FormattedDate);
});
I have tried with above scripts the logs in script include are not showing and in client script alert response is showing as null
that's what I informed, it can't be consistent as the date format depends on the logged in user's date format.
User can change the date format anytime from preferences so your script will fail.
Please inform your customer about this.
If my response helped please mark it correct and close the thread so that it benefits future readers.
