Please help with date/time format.

[Annie10]

Hello,

Currently, the start date/time format looks like this:

I need help on modifying the below script to out put looks like this format:

Example:  03-15-2024  04:24:37 PM

Here is the code I used it in Script Background :   THANK YOU

var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('sys_id','89a075671b7cc610925dc910604bcb51');
ritm.query();
if (ritm.next()) {
var dateFieldValue = ritm.variables.select_start_date_and_time;
gs.print('Start Date: '+ dateFieldValue);
}

[Isela Phelps]

Maybe something like this? 

var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('sys_id', '89a075671b7cc610925dc910604bcb51');
ritm.query();
if (ritm.next()) {
    var dateFieldValue = ritm.variables.select_start_date_and_time;
    var dateTime = new GlideDateTime(dateFieldValue);
    
    // Formatting the date
    var formattedDate = dateTime.getDisplayValue('MM-dd-yyyy');
    
    // Formatting the time
    var formattedTime = dateTime.getDisplayValue('hh:mm:ss a');
    
    gs.print('Start Date: ' + formattedDate + ' ' + formattedTime);
}

[Annie10]

Thank you, @Isela Phelps 

After running the script, I am getting the following error:

Javascript compiler exception: Can't find method com.glide.glideobject.GlideDateTime.getDisplayValue(string). (null.null.script; line 9) in:
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('sys_id', '89a075671b7cc610925dc910604bcb51');
ritm.query();
if (ritm.next()) {
    var dateFieldValue = ritm.variables.select_start_date_and_time;
    var dateTime = new GlideDateTime(dateFieldValue);
    
    // Formatting the date
    var formattedDate = dateTime.getDisplayValue('MM-dd-yyyy');
    
    // Formatting the time
    var formattedTime = dateTime.getDisplayValue('hh:mm:ss a');
    
    gs.print('Start Date: ' + f...

[AshishKM]

Try with below code.

var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('sys_id','89a075671b7cc610925dc910604bcb51');
ritm.query();
if (ritm.next()) {
var dateFieldValue = ritm.variables.select_start_date_and_time;
// ensure that "dateFieldValue" is  GlideDateTime() type object. 
gs.print('Start Date: '+ formatDate(dateFieldValue,g_user_date_format);
}

[Annie10]

Hello @AshishKM ,

Thank you!

I am getting the following error:

Evaluator: com.glide.script.RhinoEcmaError: "formatDate" is not defined. script : Line(7) column(0) 4: if (ritm.next()) { 5: var dateFieldValue = ritm.variables.select_start_date_and_time; 6: // ensure that "dateFieldValue" is GlideDateTime() type object. ==> 7: gs.print('Start Date: '+ formatDate(dateFieldValue,g_user_date_format)); 8: }