Need a client script to fetch date which is exactly one year from today in dd-MM-yyyy format
- In sam_sw_product_lifecycle, lookup for records with below conditions:
- Lifecycle Phase (lifecycle_phase) is End of Life
- Product (norm_product) is not empty
- Phase start date (start_date) is exactly 1 year from today
that phase start date output should be exactly one year from today in dd-MM-yyyy format
below is the record i should be able to fetch in the output
1 ACCEPTED SOLUTION
As per your requirement it's server side code and seems to be scheduled job etc
You need to calculate 1 year in script, simply use this in server side
// Get today's date and format it to dd-MM-yyyy
var today = new GlideDateTime();
var oneYearFromToday = new GlideDateTime();
oneYearFromToday.addYears(1);
var formattedDate = oneYearFromToday.getLocalDate().toString().split('-').reverse().join('-');
// GlideRecord to query sam_sw_product_lifecycle table
var gr = new GlideRecord('sam_sw_product_lifecycle');
gr.addQuery('lifecycle_phase', 'End of Life');
gr.addNotNullQuery('norm_product');
gr.addQuery('start_date', oneYearFromToday);
gr.query();
// Process the results
while (gr.next()) {
gs.info('Record found with start_date exactly one year from today: ' + formattedDate);
}Output: When I ran the script in background for sys_user and date field and it gave me correct output, 1 year from today is 6th April 2026
If my response helped please mark it correct and close the thread so that it benefits future readers.
