Need to display weekday name and date in MM-DD format below the day name in header.

ricksam · ‎12-18-2014

Hi All,

I need to develop code for below shown format.

I got the day format using glide script and also got the date format in html. But its difficult to bind both of them in dynamic content and display.

Please suggest. I am a beginner for service now and not able to do this within timeline.

ricksam · ‎03-19-2015

Hi Adam,

Sorry to reply late. I was so busy in work. Didn't check it.

Yes I got another way of doing this in Macro. Please reply if this is helpful. I have not tried Harish's code.

Code:-

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<g:evaluate>

var days = new Array('', 'Mon', 'Tues', 'Weds', 'Thurs', 'Fri', 'Sat', 'Sun');

var months = new Array('','01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');

var dates = new Array('','01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31');

var datetoday = new GlideDateTime();

var today = days[datetoday.getDayOfWeek()];

var day1name = new GlideDateTime(gs.daysAgo(1));

var day1 = days[day1name.getDayOfWeek()];

var date1= months[day1name.getMonth()]+"-"+ dates[day1name.getDayOfMonth()];

var day2name = new GlideDateTime(gs.daysAgo(2));

var day2 = days[day2name.getDayOfWeek()];

var date2= months[day2name.getMonth()]+"-"+ dates[day2name.getDayOfMonth()];

var day3name = new GlideDateTime(gs.daysAgo(3));

var day3 = days[day3name.getDayOfWeek()];

var date3= months[day3name.getMonth()]+"-"+ dates[day3name.getDayOfMonth()];

var day4name = new GlideDateTime(gs.daysAgo(4));

var day4 = days[day4name.getDayOfWeek()];

var date4 = months[day4name.getMonth()]+"-"+ dates[day4name.getDayOfMonth()];

var day5name = new GlideDateTime(gs.daysAgo(5));

var day5 = days[day5name.getDayOfWeek()];

var date5=months[day5name.getMonth()]+"-"+ dates[day5name.getDayOfMonth()];

var day6name = new GlideDateTime(gs.daysAgo(6));

var day6 = days[day6name.getDayOfWeek()];

var date6= months[day6name.getMonth()]+"-"+ dates[day6name.getDayOfMonth()];

var day7name = new GlideDateTime(gs.daysAgo(7));

var day7 = days[day7name.getDayOfWeek()];

var date7=months[day7name.getMonth()]+"-"+ dates[day7name.getDayOfMonth()];

</g:evaluate>

<br/>

${day1}

${date1}<br/>

${day2}

${date2}<br/>

${day3}

${date3}<br/>

${day4}

${date4}<br/>

${day5}

${date5}<br/>

${day6}

${date6}<br/>

${day7}

${date7}<br/>

</j:jelly>

View solution in original post

Harish Murikina · ‎12-18-2014

Hi Ricky,

What is 12-14 ,12-15 here.

Can you send your code.

Regards,

Harish.

ricksam · ‎12-19-2014

Hi Harish,

The outcome should be like blelow.

DAYNAME

MM-DD

example;- Sun

12-18

I need to get previous 5 days in the header as given above.

My code below to get previous days:-

<g:evaluate var="jvar_day">

var todayname = new GlideDateTime(gs.daysAgo(0));

var today = todayname.getDayOfWeek();

var day1name = new GlideDateTime(gs.daysAgo(1));

var day1 = day1name.getDayOfWeek();

var day2name = new GlideDateTime(gs.daysAgo(2));

var day2 = day2name.getDayOfWeek();

var day3name = new GlideDateTime(gs.daysAgo(3));

var day3 = day3name.getDayOfWeek();

var day4name = new GlideDateTime(gs.daysAgo(4));

var day4 = day4name.getDayOfWeek();

var day5name = new GlideDateTime(gs.daysAgo(5));

var day5 = day5name.getDayOfWeek();

var day6name = new GlideDateTime(gs.daysAgo(6));

var day6 = day6name.getDayOfWeek();

var day7name = new GlideDateTime(gs.daysAgo(7));

var day7 = day7name.getDayOfWeek();

today;

day1;

</g:evaluate>

<j:if test="${jvar_day == 0}">

Day: Sun

</j:if>

<j:if test="${jvar_day == 1}">

Day: Mon

</j:if>

<j:if test="${jvar_day == 2}">

Day: Tues

</j:if>

<j:if test="${jvar_day == 3}">

Day: Weds

</j:if>

<j:if test="${jvar_day == 4}">

Day: Thurs

</j:if>

<j:if test="${jvar_day == 5}">

Day: Fri

</j:if>

<j:if test="${jvar_day == 6}">

Day: Sat

</j:if>

</j:jelly>

Harish Murikina · ‎12-19-2014

Hi Ricky,

I have written the code by using javascript. It will display details below .

Check here i have done in demo.

https://demo011.service-now.com/login.do

Username and Password : admin

Once you login click this link : ServiceNow

It will show like below . You can modify code as per you.

Here is the code.

________________________________________________________

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<html>

<head>

function checkDetails()

{

var answer = '12-14@@12-15@@12-16@@12-17@@12-18@@12-19@@12-20';

var record=answer.split('@@');

myFunction2(record);

}

function myFunction2(answer2)

{

var tbl = document.getElementById("tbl1");

var tBody = document.createElement("tbody");

var row = document.createElement("tr");

var coll1 = document.createElement("td");

var coll2 = document.createElement("td");

var coll3 = document.createElement("td");

var coll4 = document.createElement("td");

var coll5 = document.createElement("td");

var coll6 = document.createElement("td");

var coll7 = document.createElement("td");

var collText1 = document.createTextNode(answer2[0]);

var collText2 = document.createTextNode(answer2[1]);

var collText3 = document.createTextNode(answer2[2]);

var collText4 = document.createTextNode(answer2[3]);

var collText5 = document.createTextNode(answer2[4]);

var collText6 = document.createTextNode(answer2[5]);

var collText7 = document.createTextNode(answer2[6]);

coll1.appendChild(collText1);

coll2.appendChild(collText2);

coll3.appendChild(collText3);

coll4.appendChild(collText4);

coll5.appendChild(collText5);

coll6.appendChild(collText6);

coll7.appendChild(collText7);

row.appendChild(coll1);

row.appendChild(coll2);

row.appendChild(coll3);

row.appendChild(coll4);

row.appendChild(coll5);

row.appendChild(coll6);

row.appendChild(coll7);

tBody.appendChild(row);

tbl.appendChild(tBody);

}

</script>

</head>

<th>Sunday</th>

<th>Monday</th>

<th>Tuesday</th>

<th>Wednesday</th>

<th>Thursday</th>

<th>Friday</th>

<th>Saturday</th>

</tr>

</table>

</span>

</body>

</html>

</j:jelly>

_______________________________________________

Regards,

Harish.

ricksam · ‎12-19-2014

I need to use it in CMS. So I am creating the dynamic content.

For the headers I need dynamic dates. Means everyday it will refresh. Watever the date is, the header should display previous 5 days date.

Please help. You are really my saviour.