Date question

[LastCyborg]

I have a Field that contains a Date, but I need to show that Date plus 8 days, is there an easy way to do this or I have to code the function?

Example:
RecordField = 01/01/04
DataToShow = 09/01/04

The problem is when I have to change the mont or year, etc

--- LastCyborg ---

 

[TheAceMan1]

How are ya LastCyborg . . . . .

Something like:

[blue]   DateToShow = RecordField + 8[/blue]

Be aware:

[blue]Integer of Date = Date Part

Fractional Part = Time Part

1 Day = 1
1Hour = 1/24 = 4.16666666666666666666666666666e-2
1 Minute = 6.94444444444444444444444444444e-4
1 Sec = 1.15740740740740740740740740740e-5

12 Noon = .5[/blue]

See Ya! . . . . . .

 

[LastCyborg]

I tried it, but appears #Error in TextBox where I put that

 

[txaccess]

You need to use the DateAdd Function

DateAdd("d", 8, me.RecordField)


I haven't failed, I have just found 10,000 ways that it won't work!

 

[TheAceMan1]

LastCyborg . . . . .

For an unbound textbox, the [blue]ControlSource[/blue] property should be:

[blue] = DateFieldName + 8[/blue]

In VBA its:

[blue]Me!TextBoxName = Me!DateFieldName + 8[/blue]

If your still having problems, post back what your using & where you your using it. . . .

[blue]txaccess[/blue] . . . have you tried it?

See Ya! . . . . . .