I have an Expiration Notification workflow where i would like to send the reminder notification 30 days before the expiry date. I have used the Calculate Date action to get the reminder date as shown below. But this always returns the date with the default time set as 12:00 AM.
For example: 6/19/2017 12:00 AM
So, when i used the action 'Pause Until', this is always checking the current date & time with the reminder date & time.
If i give the Expiry Date is 8/11/2017 and the reminder date shows as 7/12/2017 12:00 AM. So, 'Pause until' action compares the today's date: 7/12/2017 12:22 PM with the reminder date: 7/12/2017 12:00 AM and so, it will not execute the next statements.
So, I don't want to include the time here, please let me know if any one has any suggestions on it.