Re: Date manipulation

From: "ruralguy via AccessMonster.com" <u12102@uwe>
Date: Mon, 30 Jul 2007 15:10:19 GMT

Here's some links you might find useful:
A plethora of date functions
http://www.pacificdb.com.au/MVP/Code/Dates.htm
Functions for calculating and for displaying Date/Time values in Access
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B210604

Chris wrote:

I need to find a way to write a query that will return the date of the
Friday of four weeks ago. So, if I use today's date (7/30), I should
be returning 7/6 as 4 weeks ago on Friday. Any help is appreciated.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200707/1

.

References:
- Date manipulation
  - From: Chris

Prev by Date: Re: Access Jet-Engine versus MSDE / SQL
Next by Date: Printing labels has a glitch
Previous by thread: Date manipulation
Next by thread: Playing a sound file from VBA?
Index(es):
- Date
- Thread

Relevant Pages

Form "Calculating"
... Chris ... "Calculating" but would ... >going on, watch values etc? ... timer of some sort ...
(microsoft.public.access.forms)
Re: Graphics Tile Engine - GTE
... I found that a google Web and Image search for "sprite sheet" yields a ... plethora of tiles. ... // CHRIS ...
(comp.sys.apple2.programmer)
Re: XOR on string
... generally just acronyms ... was just calculating the lrc on one extra digit that I should have ... Chris ...
(comp.lang.python)