Referncing today's date

[hallingh]

I've done this in the past, but can't remember how to do it. I'm subtracting a date from today's date using vba, and I can't remember how to reference today's date. Right now I have:

Date(Today())

But that's giving me an error. Any help would be greatly appreciated. Thanks!

Hank

 

[Scott Huish]

Try Int(Now)

Sub test()
Dim d As Date
d = #1/23/2010#
MsgBox Int(Now) - d
End Sub

 

[hallingh]

Perfect. Thanks a lot!

Hank