I wanna set a Calendar to default as NOW

[Grizlore]

I wanna set a Calendar to default as NOW

I have a Userform which has a calendar object included.
When my Userform opens, i have the code

Calendar1 = Now

, this doesnt seem to set the date as todays date. It is tomorrows?

I'm sure this is a simple fix.

Could someone help please.

Thanks & Regards

 

[bsnapool]

try Now()

 

[Grizlore]

try Now()

Tried that & no joy. I'm sure it's something as equallysimple though.

Thanks anyway!

 

[bsnapool]

Or what about Now -1

 

[Grizlore]

Or what about Now -1

I could, and have as a fix, but that's just not right!

i wanna know the proper way, or why it's not working.

 

[BJungheim]

Try

Calendar1 = Date

 

[Grizlore]

Try

Calendar1 = Date

seem to have done the trick, Thanks

I'd still like to know why the NOW didnt work though!

Thanks

 

[Richard Schollar]

Now returns the current date&time as a decimal (ie I get 38,986.55 if I plug =NOW() into an excel cell). The date function, on the other hand, only returns the integer part of the date ie 38,986. I suspect that your calendar control therefore is rounding up the value it gets passed (or may simply be rounding it to closest integer whether greater or less than Now, depending on when you call the function).

Best regards

Richard