PC Review


Reply
Thread Tools Rate Thread

AUTOMATICALLY INSERT DATE 3 DAYS HENCE

 
 
=?Utf-8?B?S0VWSU4=?=
Guest
Posts: n/a
 
      20th Feb 2006
NEED TO INSERT DATE THREE DAYS FROM THE DATE THE DOCUMENT IS POSTED. SINCE
THIS IS ROUTINE I WOULD LIKE TO HAVE THIS DONE AUTOMATICALLY. CAN I INSERT A
DATE+3?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?T2Zlcg==?=
Guest
Posts: n/a
 
      20th Feb 2006
If the DATE THE DOCUMENT IS POSTED is a field in a table, you can achieve
that using a query
In the query create a new field
NewDate: DateAdd("d",3,[DATE THE DOCUMENT IS POSTED FIELD NAME])

Or
NewDate: [DATE THE DOCUMENT IS POSTED FIELD NAME] + 3


--
\\// Live Long and Prosper \\//
BS"D


"KEVIN" wrote:

> NEED TO INSERT DATE THREE DAYS FROM THE DATE THE DOCUMENT IS POSTED. SINCE
> THIS IS ROUTINE I WOULD LIKE TO HAVE THIS DONE AUTOMATICALLY. CAN I INSERT A
> DATE+3?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I insert Field which will be 7 days from Date Doc Created? TCH Microsoft Word Document Management 1 10th Nov 2009 07:22 PM
Insert date plus 20 days JWNich Microsoft Word Document Management 1 4th Sep 2008 09:20 PM
How do I insert a date that is always 7 days in advance of today Waterhun Microsoft Excel Misc 3 19th Jun 2008 08:12 PM
How to insert future date based on current date plus 14 days =?Utf-8?B?Sm9obiBCYWtrZXI=?= Microsoft Word Document Management 1 31st Jan 2005 09:08 PM
insert the date automatically, and insert a number automatically KC Microsoft Excel Worksheet Functions 3 16th Mar 2004 10:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:16 PM.