Why Doesnt this work? (Probably a stupid Date Question)

  • Thread starter Mark Stephenson
  • Start date
M

Mark Stephenson

Hi,

Can anyone tell me what I am doing wrong??

------------------------
if Now() = #06-08-04# Then
Do something....

I realise that this is probably a really stupid question, but if someone can
steer me into the light, i would appreciate it!!

Many thanks,


Mark.
 
K

Ken Snell

Now contains both date and time. Your expression will work only at midnight.

Try
If Date() = #06-08-04# Then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A couple questions BEFORE using Office 365 0
This is probably a dumb question, what is macros? 1
Calculating Work Time 7
Message boxes 5
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Cells not updated automatically 3
Autofill Date in Word 15.33 for Mac 0
Find then highlight in yellow 6

Top