Help! Date/time struggles

[pholt33]

I have a process where a timestamp is created. Once that timestamp is created, the user has until the end of the next business day (weekday is fine if incorporating holidays is more difficult) to finish a process. If the process isnt completed in time, their approval expires and they need to get reauthorization to do what needs to be done.

What I was thinking is to calculate the time until midnight 2 days from the timestamp (effectively the end of the next weekday). If current real time is beyond that midnight time frame, the record expires.

Step 1 - determine the ending allowable time

Step 2 - compare current time to ending allowable time

Step 3 - expire the record if current > allowable. Id like to have this step send an alert email to the person who didnt finish the process and then delete that specific record, or otherwise make it not editable.

I cant figure out how to do step 1. I can add 2 days or other things like that, but I havent figured out how to do the calculation based on a specific time for a future date.

Thanks for your help!

 

[namliam]

to get 23:59 of tomorrow, date + 2
then if you want to allow for weekends, use the weekday function inside an IIf to check if today is friday, then add 2 more days...

Yes allowing for holidays is significantly harder, though not undoable.