Re: Start date

RevStartDate = IIf(Weekday([StartDate], 2)<=5, [StartDate],
[StartDate]-(Weekday([StartDate],2)-5))

When using Monday (i.e., 2) for the StartOfWeek argument, Saturdays returns
6 and Sundays returns 7)
So: If StartDate <= Friday, use StartDate, otherwise subtract 1 or 2 from
StartDate (i.e., use Friday)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Nelson Medeiros via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:3c17e21ca98540c3bb4ec47cfcd785e0@xxxxxxxxxxxxxxxxxxxx
>I currently have a startdate column and I need help on how to create a
> formula that looks at all weekend days and return them to friday in this
> query. Can someone Help.
>
> Thanks


.

Relevant Pages

  • Re: Work scheduling/rostering in Access 2000
    ... Each engineer has a 16-day cycle, and each engineer's cycle is phased 4 days later than the previous one; all that's required, really, is a start date to anchor the whole calculation. ... StartDate = StartDate + 8 Case "C" ... HTH, ...
    (microsoft.public.access.formscoding)
  • Re: Microsoft Office 2002 Developer??
    ... >> HTH, ... >> George Nicholson ... >> Remove 'Junk' from return address. ... >>> I know it comes in the 2000 Developer edition, but in 2003, it comes as ...
    (microsoft.public.access.replication)
  • Re: time conversion GMT to Pacific
    ... > I want a forumulae or function to convert this to read 16:00:00 pm PST ... >> HTH, ... >> George Nicholson ... >> Remove 'Junk' from return address. ...
    (microsoft.public.excel.misc)
  • Re: Error in http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Exc
    ... have a worksheet named Sheet2? ... HTH, ... George Nicholson ... Remove 'Junk' from return address. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SQL 255 Limit workarround??
    ... > See http://www.QBuilt.com for all your database needs. ... >>> HTH, ... >>> George Nicholson ... >>> Remove 'Junk' from return address. ...
    (microsoft.public.access.modulesdaovba)