Re: rendered date

From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
Date: Sat, 31 Dec 2005 01:08:32 GMT

Bill wrote:
> Is there some sort of formula that anyone knows of that it if provied
> it was a date it will tell me was the date was a number of days before
> it.
>
> Ex.. Say i put in a 12/29/2005 as a starting point and I want to know
> what the date was 90 days ago....

=DateAdd("d", -90, YourDate)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

.

References:
- rendered date
  - From: Bill

Prev by Date: Re: VBA for ACCESS
Next by Date: Re: =Iff(([Me]![Gender])="M","Male","Female")
Previous by thread: Re: rendered date
Index(es):
- Date
- Thread

Relevant Pages

Sorting
... What I need to do is to sort the names of colours in column b ... alphabetically, but retaining their present numbers, so if at present row ... Bill ... Prev by Date: ...
(microsoft.public.excel.newusers)
Re: Sorting (Anne)
... >The sorting is sorted thanks to a good sort on here. ... >play as well and found out a few other bits. ... Bill ... Prev by Date: ...
(microsoft.public.excel.newusers)
Re: Tab change event
... Bill wrote: ... > run the code once using tabindex numbers. ... RBrandt at Hunter dot com ... Prev by Date: ...
(microsoft.public.access.formscoding)
Re: Sorting
... >> Bill: Whenever you sort, as a rule, don't select the area you're ... If you simple click in, for instance, B2, and hit the sort ... >> Anne Troy ... Prev by Date: ...
(microsoft.public.excel.newusers)
Re: Name of form that invoked report
... Bill wrote: ... > issued the DoCmd OpenReport? ... RBrandt at Hunter dot com ... Prev by Date: ...
(microsoft.public.access.reports)