Script Help

yoli1
Tera Contributor

Hello all, I need help with a script.

This is my path: test/2024/02/05/test_20240204.csv. What I want is for the date to change whenever I call the script. I want the first day to be today's date, and the other date to be -1 day from today

yoli1_2-1707137649305.png

 

Thank you.

2 REPLIES 2

DYCM
Mega Sage

Hi @yoli1 , my bad, please check the updated version

// Using GlideDate
var gd = new GlideDate();
var currentDate = gd.getValue(); 
var currentDateInRequiredFormat = currentDate.split('-').join('/'); 

// Using GlideDateTime
var gdt = new GlideDateTime();
var currentDateTime = gdt.getValue(); 
var currentDateInRequiredFormat = currentDateTime.split(' ')[0].split('-').join('/'); 

gs.info(currentDateInRequiredFormat);


var gdt = new GlideDateTime(); 
gdt.addDaysUTC(-1); 

var year = gdt.getYearUTC().toString();
var month = (gdt.getMonthUTC()).toString().padStart(2, '0'); 
var day = gdt.getDayOfMonthUTC().toString().padStart(2, '0'); 

var dateYesterday = year + month + day; 
gs.info(dateYesterday);

 

yoli1
Tera Contributor

Hi @DYCM , thank you for your reply, but the script changed the month and added 1, so from 02 to 03. See below

yoli1_0-1707139211292.png