Is Date Odd or Even?

's Computer Specifications

Hi All.........
I am trying to create a macro that will test the DATE, and if it is an ODD
number, run Macro1, and if it is an EVEN number, run Macro2........

Can't seem to get there.......help please.

Vaya con Dios,
Chuck, CABGx3

's Computer Specifications

Based on the day?

if day(date) mod 2 = 1 then
call OddMacro
else
call EvenMacro
end if

CLR wrote:
>
> Hi All.........
> I am trying to create a macro that will test the DATE, and if it is an ODD
> number, run Macro1, and if it is an EVEN number, run Macro2........
>
> Can't seem to get there.......help please.
>
> Vaya con Dios,
> Chuck, CABGx3

--

Dave Peterson

's Computer Specifications

So cool it is.................thanks Dave

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:

> Based on the day?
>
> if day(date) mod 2 = 1 then
> call OddMacro
> else
> call EvenMacro
> end if
>
>
>
> CLR wrote:
> >
> > Hi All.........
> > I am trying to create a macro that will test the DATE, and if it is an ODD
> > number, run Macro1, and if it is an EVEN number, run Macro2........
> >
> > Can't seem to get there.......help please.
> >
> > Vaya con Dios,
> > Chuck, CABGx3
>
> --
>
> Dave Peterson
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date?	Amanda	Microsoft VB .NET	2	10th Oct 2006 06:52 AM
Link date to a table with Date Range (Eff Date and term date)	=?Utf-8?B?S2V2aW4gUmVlZA==?=	Microsoft Access	1	31st Aug 2006 04:23 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 01:08 AM
Run Query from date to date, Print the from date to date in the header of the report?	Dustin Swartz	Microsoft Access Queries	1	25th Jan 2005 07:06 PM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 01:51 PM