Skip to main content

First time posting! Hello, I have a list that is being utilized to manage project requests. These requests have an option for a "duration" (15, 30, 60 or 90 days). I have created a calculated column that takes the user's choice and applies an "Expiration Date", which is their choice of duration represented in date form. I have a need to send a reminder email to the creator of the item 10 days before the "Expiration Date". I have looked through every past post and article I could find but I haven't had any luck putting it all together. 


I have attached a screenshot of my scheduled site workflow:


Calculate Date sets "Today's Date" in a variable: varReminderDate


Query List queries the list when the Expiration Date column is equal to varReminder Date


I also have the "Field" set to Expiration Date and the variable to "sendemailremindervar"


When I run this, it does not return anything - Expiration_x0020_Date:


 


For each sets collection to "varsendemail"


Store result in "varstoreresult"


 


Send notification is set to send to me as a test, though I will be setting that to the creator of the list item.


Can anyone guide me on what I may be telling it to do incorrectly? I can provide any other needed info!


Thanks!

I wanted to update this issue. I have updated my workflow to set a variable for "Today's Date". I also used the "Set Variable" action to set a second variable "ReminderDate" to the value of my calculated column, aptly named "Reminder Date" which is set to today's date. I have set a "Run If" action to run if varReminderDate equals VarTodaysDate.


However, my email never sent. I put in a log and see that that the variable for Today's Date is accurate, but the variable for ReminderDate is 1/1/0001. 


Anyone run into this before?


I checked around and made sure my column was set to Date/Time but havent found any other areas to modify.


Reply