GMR Admin
11/14/2024, 4:06 PMGMR Admin
11/14/2024, 4:07 PMfunction isDateInOpenPeriod(date) {
var formattedDate = format.format({
value: date,
type: format.Type.DATE
});
var openPeriodSearch = search.create({
type: search.Type.ACCOUNTING_PERIOD,
filters: [
['closed', 'is', 'F'], 'AND',
['arlocked','is','F'], 'AND',
['startdate', 'onorbefore', formattedDate], 'AND',
['enddate', 'onorafter', formattedDate], 'AND',
["isquarter","is","F"], "AND",
["isyear","is","F"]
],
columns: ['internalid', 'periodname']
});
var result = openPeriodSearch.run().getRange({ start: 0, end: 1 });
return result.length > 0;
}
GMR Admin
11/14/2024, 4:19 PM