Today()

[Kavy]

Hello All
Question
I am trying to use the dateadd code in a vb user form in excel. What I am doing is

start = Today
start = dateadd("yyyy", interval, start)

Where interval is the interval set from other code.
My problem is I can''t get it to find todays date, Today() or Today does not work, and Now() or Now gives me the time with it, and i need to compare dates, and my other dates don't have time so the comparsion later does not work.

Any ideas?

 

[Kavy]

ahh using Date and working, sorryfor the post

 

[madchemist]

you could try

start = Date

 

[Kavy]

thanks!