[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Add 1 to a date field

Posted on 2006-05-10
3
Medium Priority
?
171 Views
Last Modified: 2013-12-18
I have a field called DateM. I want to have 6 more fields that are dates and each one adds one day to the previous one.

So if someone enters 6/8/06 in Date M, the others would compute when composed as such (and couldn't be edited)

DateT     6/9/06
DateW    6/10/06
DateH     6/11/06
DateF     6/12/06
DateSa   6/13/06
DateSu   6/14/06

Help!
0
Comment
Question by:aeonflux2
1 Comment
 
LVL 15

Accepted Solution

by:
mshogren earned 2000 total points
ID: 16653672
You should make these fields computed and put the following formula in as their computed values respectively:

@Adjust(DateM; 0; 0; 1; 0; 0; 0)
@Adjust(DateM; 0; 0; 2; 0; 0; 0)
@Adjust(DateM; 0; 0; 3; 0; 0; 0)
@Adjust(DateM; 0; 0; 4; 0; 0; 0)
@Adjust(DateM; 0; 0; 5; 0; 0; 0)
@Adjust(DateM; 0; 0; 6; 0; 0; 0)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question