Show a date 30 days out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].

Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
Jan 07.

I did =[Sold date]+30 and it did not work

Thanks
 
Thanks Steve!!

molsonexpert said:
how about dateadd:

dateadd("d", 30, [Sold Date])

--
steve.


KAnoe said:
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].

Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later
31
Jan 07.

I did =[Sold date]+30 and it did not work

Thanks
Click to expand...
Click to expand...
 
Back
Top