I'm trying to create a dynamic filter option on ends field for the delegate record. I want to take the current date add 1 week with the time defaulted to 23:59:59. I am able to add 1 week but I cannot figure out how to get the time to get set to 23:59:59. Right now the default was set to 1st day of 2100 which doesn't make sense as who because who has 74 years of vacation time available.
Edit: This is what I came up with. It works fine in scrips background but does not work in dynamic filter.
var d = new GlideDateTime(); d.addDays(7); var datePart = d.getDate();d.setValue(datePart + " 23:59:59");
