Time Function

[alihussain19]

I need to get the current day in a Macro, How could I do this!!!
I need to compare it with the Day in my OutLook Calendar.

 

[Tod]

You can use Date, like this:

Dim MyDate as Date

MyDate = Date

 

[Bob Phillips]

If you want the day name, try

Format(date,"ddd")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ijb]

Dim MyDate
MyDate = Date

or to include time too

mydatetime = now()

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help