Hello, so within my Manual Wire Request Process, I created a timer to send Remin

krystleb over 11 years ago

Hello, so within my Manual Wire Request Process, I created a timer to send Reminder E-mails every 2 Hours based on the Settle Date. I also have a universal timer that kills the process at 3 PM of the Settledate. I use the pv!startTime to capture the Hour the Reminder E-mail will be Sent. For one of my instances the E-mail gets sent at 9 AM, 11 AM, & 1 PM. Then the start time does not update to 3 PM. Instead, the reminder e-mail gets sent every minute after 1 PM.

Is it possible that since the Next Start Time is supposed to be at 3 and I also have a Universal Timer that sets to kill the process at 3, that they are conflicting ideas? Or is there an issue with the expression I am using to add 2 hours to my start time?

if(pv!nineAmComplete=true,pv!startTime,hour(local(now()))+2)

Thank You....

Discussion posts and replies are publicly visible

0 jamesw353 over 11 years ago

I always have trouble when modifying date & times as well. For readabilities sake the best way of found is to use the datetime() function then enumerate each piece of that call using now() with the appropriate container.

For example:
datetime( year(now()), month(now()), day(now()), hour(now())+2)
There's probably a more condensed way to add 2 hours to the current time, but this is the simplest and most easy to understand way I've found. When I tried the expression you posted it actually adds two days the now().

Also be wary of timezone settings when you're evaluating this. You may not need to use local(), and it may actually be adjusting out of your timezone.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jamesw353 over 11 years ago

I just realized I left the minute off of my example. If you want to maintain the minute setting just add it to the parameters like so...
datetime( year(now()), month(now()), day(now()), hour(now())+2, minute(now()))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 krystleb over 11 years ago

Thanks, James. This is insightful...I think I know what may have caused my issue, now I just need to test it out. Happy Holidays and have a Safe & Prosperous New Year :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel