.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Email when a due date is reached

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Very similar problem to the one was previously sent.  I'm using Sharepoint Designer 2007 trying to create a custom workflow on a document library. The customer is uploading documents and wants to set a due date for each one. I've created a due date column in the library set as a date content type. This is a static field. The date they enter won't change unless they want it to. I've also set another date field to default to the current date. This field will change as the date changes. The customer would like an alert email sent out one day after to the due date to the parties involved with a particular document or library.

Any help is appreciated. Thank you.


has very kindly suggest the following solution, BUT though I know how to create a variable on Workflow in Sharepoint design BUT not sure how to store value DueDate +1 to it?

Just create a workflow on item added & add the following steps.

  1. Create a workflow variable (say MailDate) and store the value DueDate-1.
  2. Use the activity Pause Until MailDate
  3. Send the mail with required contents.
  4. Stop the workflow.

As simple as this :)


View Complete Post

More Related Resource Links

AUTOMATICALLY send an email on a future date

HiI would like to achieve the following. 1- if a user goes to a web page in a web application hosted on the Internet and selects a FUTURE date from a "Calendar control" the date selected and the URL for the page are stored in the database (I know how to do this step) 2- when the date selected arrives the URL will be embedded in an email that is sent out AUTOMATICALLY to the user. How can I trigger the email to go out AUTOMATICALLY on the selected date?????? Does the link below help me answer this question??  I just need a high level steps on how to do this. Your help is greatly appreciated. http://msdn.microsoft.com/en-us/magazine/cc163821.aspx

Send a reminder email 1 month before renewal date




I have a custom list with information about our customers and when we need to renew there equipment. When we add entries to the list we have field called Renewal date where we select the date the equipment needs renewing.


I would like to create a workflow so I can select the entry click on workflows and set the entry to email me 1 month before the renewal is due.


I am using SBS 2008 and WSS 3.0


Thanks in advance

SharePoint Portal Server 2003 - email alert based on due date


Hello All,

Hoping someone can help us here.

Note:Workflow/3rd party solutions not an option-

We would like to send an email alert when a list items due date is eqaul to "today".

We are trying to manage some certificates of compliance by flagging the "due date of the particular certificate (list item)" and sending an alert email when that occurs.

Is this feasible in any manner without workflow?

Is it possible to send an alert based on a calculated field when that calculated data changes? .

Any direction would be appreciated.

Thank you

Mike Harvey
Software Solutions Architect


Set a review date on a document and be alerted by email

I need to set a review date on a document in a sharepoint 2010 document library and then receive an email when that date is reached. What is the best way to achieve this? Thanks!

Sending Email alerts before expire date on document (using Sharepoint Designer)


I need to trigger an email alert 2 weeks before the expire date on document (document library).


The document library has a List/Site Column for an Expiry date.

I need to clarify the following:


I assume it is possible to create a CALCULATED field (Alert Date) of DATE (assigned to List/Site Column) that would

have a formula of: Expiry date - 14 days. 


Is it possible to trigger a workflow (created in Sharepoint Designer) AFTER the Alert + Expiry dates have been set

and ONLY if the Alert Date  = Todays Date? 


Is it possible to add a variable in the workflow of type DATE that MAPPED to the current item 'UPLOADED' to the

Document Library and was calculated against the number of days to be subtracted?


If this was possible could it be bound to the PAUSE UNTIL DATE action?


The Workflow would only then be triggered (p

What is the default in the Three State Workflow for how many days after due date to send email remin

I am setting up Three-State Workflow on an Issue Tracking list in MOSS 2007. My company does not allow SP Designer. I would like to know what is the default setting in this workflow for how many days after task due date to send the email reminder. Also, is there a way to change this setting under site collection administration? I would like it to send the reminder every 2 days.

Display date only in workflow email


I created a list for salaried employees timesheets and have 10 date columns formated as "Date Only" that is used for salaried employees to enter thier dates worked.  The time is not needed, only that they worked on a particular date. I created a workflow in SPD and in the in the workflow email, I added the date fields to the body. The resulting message displays the date and time formatted as dd/mm.yyyy 12:00 AM. This may cause some confusion for the end users.

Is there a way to only display the date in the workflow email? I've read a bit about calculated columns, but I don't know how this would work with 10 date fields in the form.

Using a CompareValidator to check input is a valid date

The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

How To Set a Date Format In GridView Using ASP.NET 2.0

A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

jQuery Date picker Implementation in ASP.NET

I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

Built-in Functions - Date and Time Functions

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.

Date and Time Data Types and Functions

The following sections in this topic provide an overview of all Transact-SQL date and time data types and functions. For information and examples that are common to date and time data types and functions
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend