Why doensn't this work

[Jimmy]

Hi everyone,

dateadd("d",-1,date()) this doesn't work
dateadd("d",-1,#13-9-2004#) this works great

But i need the first solution. I always need the date of yesterday

Can somebody help me!!

 

[adaytay]

Hi everyone,

dateadd("d",-1,date()) this doesn't work
dateadd("d",-1,#13-9-2004#) this works great

But i need the first solution. I always need the date of yesterday

Can somebody help me!!

Try being a little more expressive, and storing Date() in a variable before passing through to DateAdd.

Something like:

Dim dtDate as Date

dtDate=Date()

DateAdd("d", -1, dtDate)

This is untested, but should work...

Ad

 

[Rich]

Where are you using it? there are no brackets after Date in vba, it's just Date

 

[ray705]

I just tried your format on a form linked to a command button. Worked perfectly. How are you trying to use it?

 

[ecniv]

dateadd("d",-1,now)

 

[Rich]

dateadd("d",-1,now)

Now will add a time element into the equation and give inconsistent results, Date is correct, if it isn't working then Jimmy almost certainly has a missing reference

 

[Jimmy]

Thx ADAYTAY you were right, pretty obvious strange that date() doesn't return a date-obeject.

Thank you all for you replies (Y)

adios

 

[Rich]

strange that date() doesn't return a date-obeject.


adios

it does, like I said, without the brackets