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!
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.