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
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.