Help with finding a date ??

From: "Presto" <junkmail@xxxxxxxxxxxxx>
Date: Tue, 22 Apr 2008 18:59:09 -0400

I have two date fields.
PaymentDate - is set to default to today : =Date()
MeetingDate - is going to find the next meeting date after the PaymentDate

So using April as an example:

If today's date is 4/22/2008 , I want the MeetingDate field to look up the
NEXT meeting this month... this would show as 4/23/2008.
If today's date is 4/29/2008, then I need the query to find the NEXT meeting
date which would be 5/28/2008.
So the logic is :
If (Today is less than the fourth wednesday of current month, Then show the
fourth of this month, Else show the next fourthof the month)

How can I have this meeting date pre-fill like this?

.

Follow-Ups:
- Re: Help with finding a date ??
  - From: Albert D. Kallal

Prev by Date: Re: Print a report 3 times with 3 different fields visible
Next by Date: Re: Print mailing labels and update date field
Previous by thread: Check for field in tabledefs prior to append
Next by thread: Re: Help with finding a date ??
Index(es):
- Date
- Thread

Relevant Pages

Re: Agenda template
... I want to pre-fill out the agenda items and be able to reuse ... the list for each meeting ...
(microsoft.public.sharepoint.portalserver)
Agenda template
... how can I create a Agenda template for a Meeting ... I want to pre-fill out the agenda items and be able to reuse the ...
(microsoft.public.sharepoint.portalserver)