How to convert date format

[sheths]

Hello all,

I have an inbound action which reads content of the email and populates a table with the information from the email body.

My issues is that the email contains long format date e.g. 24th March 2014 at 23:59hrs and I need to convert this to short format dd/mm/yyyy so it can populate date field on the form.

Appreciate any help with this.

Thank you.

[Shishir Srivast]

You mean you don't want to change the system property? Sorry, may be I didn't get. Can you please little bit explain.

Let me know if I can check your SNOW instance?

[ramak]

Hey Shishir, what I meant was when I try to set the 'Date' field value via a Script include, the format doesn't get applied. This is what I'm doing:

setQuarterlyValidDate: function() {   
   var gr = new GlideDateTime();   
   gr.addMonthsUTC(3).setDisplayValue("dd/MM/yyyy HH:mm:ss");   
   gr.getDisplayValue();   
   return this._convertToGlideDate(gr);   
   },   
   
   _convertToGlideDate: function (gdt){   
   var gd = new GlideDate();   
   gd.setValue(gdt.getValue());   
   gd.getByFormat("dd/MM/yyyy");   
   return gd;   
   }, 

And this is the Client script...

var answer = response.responseXML.documentElement.getAttribute("answer"); 
var dFormat = g_user_date_format;
var tdayDate = formatDate(new Date(answer),dFormat);
 g_form.setValue('u_review_date',answer
);

Still, the Date field shows the value in 'yyyy-mm-dd' format & not in the 'dd/MM/yyyy format....   is there anything wrong???

[Shishir Srivast]

Hi Suhas,

I see

In Script Include you are using gd.getByFormat("dd/MM/yyyy"); but that is not the function to format the date, that is being used to format the time, please check here: Scoped GlideTime API Reference - ServiceNow Wiki .

Also, gd.setValue(gdt.getValue()); this is also not correct, since you are not getting any value with getValue.

In Client script below doesn't make any sense since they are not being used and also don't know what it's purpose.

1. var dFormat = g_user_date_format;  
2. var tdayDate = formatDate(new Date(answer),dFormat);

Please try below below code if it helps.

Client Script:

function onLoad() {

  var dFormat = g_user_date_format;

  var tdayDate = formatDate(new Date(),dFormat);

  g_form.setValue('u_newdate', tdayDate);

  var ajax = new GlideAjax('MyNeededDateBy');

  ajax.addParam('sysparm_name', 'neededByDateTime');

  ajax.getXML(function () {

  var neededDate = ajax.getAnswer();

  g_form.setValue('u_mydate', neededDate);

  });

}

Script Include:

var MyNeededDateBy = Class.create();

MyNeededDateBy.prototype = Object.extendsObject(AbstractAjaxProcessor, {

  neededByDateTime: function () {

  var neededDate = gs.nowDateTime();

  var gdt = new GlideDateTime(neededDate);

  gdt.setDisplayValue(neededDate, "dd/MM/yyyy hh:mm:ss");

  gdt.addMonthsUTC(3);

  return gdt.getDisplayValue();

  },

  type: 'MyNeededDateBy'

});

Note: In my instance System date format is yyyy-MM-dd and in User profile the Date Format is dd/MM/yyyy.

I am getting below result:

[ramak]

Thanks, its now working...used setDisplayValue("dd/MM/yyyy HH:mm:ss") and then getDisplayValue() methods to set the values in the Script Include and then in turn the client script just sets the value retrieved.

Cheers

[Shishir Srivast]

Perfect Suhas, Happy to contribute something for fixing your issue.

Please mark answer helpful and/or correct if I helped in solving your issue.