- Create a New Field called 'Long Date' of type String
- Click 'Advanced View'
- On 'Calculated Value' tab, check 'Calculated'
- Insert the code below into the 'Calculation' field, substituting 'resolved_at' with your field
(function calculateLongDate(current) {
var gDateTime = new GlideDateTime(current.resolved_at.getDisplayValue());
var gDate = gDateTime.getDate();
var longDateTime = gDate.getByFormat('MMMM dd,YYYY');
return longDateTime;
})(current);- Add the field to the form, under your Date field (example below)
Date/Time formats are documented here.
Similar to the Business Rule solution, it only updates on form load.
To my knowledge, date/time format is a system wide setting / user preference. I don't believe you'll be able to systematically change the display of this one field to appear as described (I could be wrong, and if I am someone please let me know); BUT ... this could work: create a new field (below the current field) that is a string and displays in the format you are talking about via a business rule. (would be just a string though, not a actual date/time field).
You would need to be a admin in your instance, if you are not already (if not, I'd consult with your admin).
Example below:
New Field called 'opened other format' [u_opened_other_format], string, 40 char
New Business rule:
When to run/table/other content in BR would depend on your use case..
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var gdt = new GlideDateTime(current.opened_at);
var monthNames = ["January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November", "December"];
current.u_opened_other_format = monthNames[gdt.getMonthLocalTime()] + " " + gdt.getDayOfMonthLocalTime() + ", " + gdt.getYearLocalTime();
})(current, previous);
Upon save it then generates as below:
Probably not the optimal way to get it to work, but it is a option.
Hopefully that points you in the right direction or helps generate some ideas!
Hi Erik,
Thanks a lot for this!
Almost there! The Business Rule seems to work but the long date is a month ahead and a day behind the short date field. So 2018-04-03 displays as May 2, 2018 and not April 3, 2018.
In your screenshot, I see that the day is the same but its a month ahead of the Opened date field.
Not sure why the BR is acting differently, as I am using the exact same code.
I'd be very grateful if you could look into this further when you have a moment.
Many many thanks!
Hi Pooja,
I tried this with Business rule. Kindly check with below Script this may help you.
>> u_hr_date we have date which we need to convert.
>> Write BR on Insert/update run on OnBefore
>> Script :
(function executeRule(current, previous /*null when async*/) {
var date_time= current.u_hr_date;
gs.addInfoMessage(date_time);
var date= date_time.split(' ')[0];
var gd = new GlideDate();
gd.setValue(date);
date=gd.getByFormat('MMMM DD,YYYY');
date_time=date;
gs.addInfoMessage(date_time);
})(current, previous);
>> Screenshot :
Kindly let me know in case you have any queries.
Regards,
Supriya S.
Kindly Hit Helpful, Reply,Mark as Correct Answer if you found useful.
