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?
