Set due date as last date of month 23:00 according caller timezone

lucky24
Tera Contributor

Hi Team,

We have 3 field

Caller - referring to the user table

due date-date time field

hire date - date field 

We have to set the last day of the month and the time should be 23:00 on the due date field of the hire date and it should be according caller's time zone.

For example -

caller - alex (America/new_york)

hire date - 05/02/2024

due date - 29/02/2024 23:00:00 (last day of hire month) it should be according to caller time zone(America/new_york)

 

Please help me with the script here.

 

thanks

1 REPLY 1

Mark Manders
Mega Patron

Check here: https://www.servicenow.com/community/hrsd-forum/set-last-day-of-month-and-time-23-59-00/td-p/2831772

 

And if it doesn't work for some reason, it may be more useful to let us know what you already did and what the last part is that you are looking for, instead of getting people that are spending there own time to help you, to do the same as others did in your previous question.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark