Custom Data type in VBA

[Ashk49]

Hi ,
Do you know how can I make custom data type in VBA?
I need to make a variable like this format:
2008-04-19 18:00:01 OR yyyy-mm-dd hh:mm:ss
I can not use Date type of VB for this .
Please help me
Thanks in Advance
Ashkan

 

[Norie]

Ashkan

Don't quite see how that's a custom data type.

Couldn't you just use format to get the required result?

varDt = Format(Now(),"yyyy-mm-dd hh:mm:ss")
Msgbox varDt

 

[Ashk49]

Hi Norie,
Thanks for answer.
Please look at the following link that is my original problem.
http://www.mrexcel.com/forum/showthread.php?p=1606690
Actually Now I change the type of my variables to:
Begin_Of_Day = Format(Now(), "yyyy-mm-dd hh:mm:ss")
End_Of_Day = Format(Now(), "yyyy-mm-dd hh:mm:ss")

But still I see them like this format: mm/dd/yyyy hh:mm:ss
That is enough to break my query.
Thanks Again
Regards
Ashkan

 

[Norie]

Ashkan

You aren't actually using your variables in the SQL, you are using the strings Begin_Of_Day and End_Of Day.

By the way I think both threads are in the wrong forums.

This forum is for questions in foreign languages and the other is for general discussion, as it's title suggests.

Contact a moderator and have them moved to more appropriate forums.

 

[Ashk49]

Hi Norie,
Thanks for advise.
Definition is on the VB and after get value use it in SQL. All in excel Macro.
Regards
Ashkan