Quick & easy one on date() function

[gussy]

In the default property of a field in a form, I'm wanting the current date...easy: date(). In another field, though, I want the date less 7 days....

I seem to recall in Vb that u could stick parameters in date(...) but for some reason it doesn't seem to happen in Access.

Anyone? Thanks.

 

[Mile-O]

=DateAdd("d", -7, Date())

 

[gussy]

Brilliant, thanks.

 

[namliam]

Mile why do you ALLWAYS use dateadd???

You can handle dates as you would integers or doubles:

=Date() -7

Will do the same but easier (or is that implicit/explicit slower whatever than using DateAdd)

Regards

 

[Mile-O]

Mile why do you ALLWAYS use dateadd?

I just do because there is a function for doing it.

Date()-7 is approximately 70% faster than DateAdd("d", -7, Date())

 

[namliam]

Where posible i use the numberic properties of date values
- days
- time(hours)

For others it harder and i to resort to DateAdd

Date()-7 is approximately 70% faster than DateAdd("d", -7, Date())

How did you figure that one out? 70% darn that a lot (of milli/nano seconds , like anyone would notice )

Regards

 

[Rich]

How did you figure that one out? 70% darn that a lot (of milli/nano seconds , like anyone would notice )

Regards

he has nothing else to do

 

[Mile-O]

How did you figure that one out? 70% darn that a lot (of milli/nano seconds

I ran both methods 100,000 times:

DateAdd("d", -7, Date()) took approx 470 milliseconds to perform 100,000 times.

Date() - 7 took approx 140 milliseconds to perform 100,000 times.

 

[namliam]

a 100,000 times! Sjees,

470 / 100,000 = 0,0047
140 / 100,000 = 0,0014

Milliseconds !!

some calc time huh ?!