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.
Solved! Go to Solution.
could you describe how does your workflow works and starts?
where do you get date " today's date: 7/12/2017 12:22 PM" from?
I've bad feeling you combine scheduled workflow with pause until which is pointless.
I created the List Workflow (not a site/scheduled workflow) and used the 'Pause until date' action to pause till the expiry date but I found that this action will check the current date & time with the expiry date. So I don't think so, this is the action to use for my requirement. So, I have created the Site Workflow & Scheduled it.
Thanks for your help.