codyhayes12
Nintex Newbie

Scheduled Site Workflow based off Calculated column Date

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!

0 Kudos
Reply
1 Reply
codyhayes12
Nintex Newbie

Re: Scheduled Site Workflow based off Calculated column Date

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.

0 Kudos
Reply