Dates and VBA; Declare Dates

[pedie]

Hi, is this the right way to declare a date variable?

[/FONT]
[FONT=Courier New]Dim x As Date[/FONT]
[FONT=Courier New]x = #9/12/2011# 'or x = me.datetextbox.value[/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]MsgBox Format(x, "MMMM")
MsgBox "Q" & Format(x, "Q")
MsgBox Format(x, "YYYY")

This seems to work but thought, why not confirm it.

 

[Norie]

If it works it's usually the right way to do it.

You don't need to confirm everything.

One thing you might need to watch out for though is that if you use Format it returns a string, which could problems with comparison and type mismatch errors.

 

[pedie]

Okay Norie, thanks. So i think what 'm doing is correct.
Sometime i just need to confirm as thing go wrong due to ignorance..
i'll use month & year instead of format then.

Thanks again.