Re: Need to restrict Fiscal periods on the demand ...

Sanjeeva Nagend · ‎08-28-2024

Hi Nizamuddin,

Thanks for your reply.

I have tried your script, for every fiscal period date was tomorrows date. But current month is not visible.

var grFiscalPeriod = new GlideRecord('fiscal_period');

grFiscalPeriod.addEncodedQuery('fiscal_type=month');

grFiscalPeriod.query();

var array = [];

while (grFiscalPeriod.next()) {

var startTime = new GlideScheduleDateTime();

startTime.setValue(grFiscalPeriod.start_date_time);

var today = new GlideDateTime();

var compareStartDate = startTime >= today;

if (grFiscalPeriod.u_physical_progress_freeze_date.isNil()) {

if (compareStartDate) {

array.push(grFiscalPeriod.name.toString());

}

} else {

var todayFreeze = new GlideDate();

var compareFreezeDate = grFiscalPeriod.u_physical_progress_freeze_date >= todayFreeze;

if (compareStartDate && compareFreezeDate) {

array.push(grFiscalPeriod.name.toString());

}

gs.info(array);

gs.info(array.length);

I have written below script but this one also didn't give the current month.

var list = '';

var grFiscalPeriod1 = new GlideRecord('fiscal_period');

grFiscalPeriod1.addEncodedQuery('fiscal_type=month');

grFiscalPeriod1.query();

while (grFiscalPeriod1.next()) {

var dat = grFiscalPeriod1.u_physical_progress_freeze_date;

var date_time = new GlideDateTime(dat);

var ans = new GlideScheduleDateTime();

ans.setValue(grFiscalPeriod1.start_date_time);

var today = new GlideDateTime();

if ((date_time >= today && ans >= today) || (ans>= date_time && ans >= today)){

list += (',' + grFiscalPeriod1.sys_id);

}

gs.info(list);

gs.info(list.length);