Add 'n' plus days to a date field in YYYY-MM-DD Format

[chatsaurav19]

Hi All,

Can someone please help me to add the logic to add 'n' plus days to a date field and format it to YYYY-MM-DD format?

Code:::

---------

var date = new Date();
var lastDay = new Date(date.getFullYear(), date.getMonth() + 1, 0);
var lastDayOfMonth = lastDay.getFullYear() + "-" +((lastDay.getMonth()+1).length != 2 ? "0" + (lastDay.getMonth() + 1) : (lastDay.getMonth()+1)) + "-" + lastDay.getDate()

var gr1 = new GlideRecord('x_inpe_gbs_inf_gbs_infrastructure_roles');
gr1.query();
while(gr1.next()){
var projectedHireDate = gr1.getDisplayValue('projected_hire_date');
if (projectedHireDate < lastDayOfMonth){
    //projectedHireDate = ( projectedHireDate + 90Days ) into YYYY-MM-DD format
 }
}

Thanks and Regards,

Saurabh Chatterjee

[Samaksh Wani · Accepted solution]

Hello @chatsaurav19 

Modify the below line with that script.

var endDate = gdt.getDate();

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Ravi Chandra_K]

Hello @chatsaurav19 

Greetings!

you can try addDays

var date = new GlideDateTime(dt);
date.addDays(14);

If my response helped please mark it correct and helpful.

Kind Regards,

Ravi Chandra.

[chatsaurav19]

Hi @Ravi Chandra_K It did work but I need to remove the Time Format attached ( 00:00:00 ).

2023-08-30 00:00:00 

[Samaksh Wani]

Hello @chatsaurav19 

Add this code in your if Statement

var gdt = new GlideDateTime(projectedHireDate);
gdt.addDaysLocalTime(7);

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[chatsaurav19]

Hi @Samaksh Wani It also worked but I need to remove the time stamp ( 00:00:00 )

2023-08-30 00:00:00