Adding Dates

[SobJim]

Hello All,

I'm trying to figure out what I need to enter into a field.

In one column I have a user defined date 04/19/2012. In another column it pulls in a number from a table ex: 60. I need to add the 60 to the 04/19/2012 to give me 6/18/2012. How would I do this?



I have attached a picture of the table.

Thanks.

[RuralGuy]

Have you looked at the DateAdd() function?

[SobJim]

I did, not sure about how to type it out though. My 60 is under column "Value" and 4/19/2012 is column "Date". How would I type it?

I tried a bunch of different ways with no success.

[SobJim]

When I used the DateAdd it would display 6004/19/2012.

[alansidman]

Is your date field in your table formatted as text or Date?

[SobJim]

I did have it set as a Text. I just changed it now, still confused on what the equation should be?!?!?

Thanks

[SobJim]

I figured it out!!

Now my next question.

Not sure how to finish this:
I need to it Subtract 3/7/2013[Code Date] from 04/19/2012[Date] if INC/Var="M" and if Inc/Var="V" I need the equation reversed.

Date Variance: IFF([Inc/Var]="*M*"

[RuralGuy]

How about starting a new thread with your new issue and posting the actual line of code you used to solve the first issue will help others that read this forum.

[SobJim]

Max/Min: DateAdd("d",[Value],[Date])

was what did it. Also fixing the formatting of the Value and Code Date columns.

[RuralGuy]

That should help, thanks. Are you going to start a new thread or do you want me to move it? BTW, using "/" in a name is not a very good idea. http://support.microsoft.com/?id=826763

[RuralGuy]

Come to think of it, "Date" is a reserved word as well: http://www.allenbrowne.com/AppIssueBadWord.html#D

[RuralGuy]

Thanks for starting the new thread. You will get more answers that way.