|
| | | Forum Newbie
Group: Forum Members
Last Login: 2/19/2009 9:00:47 AM
Posts: 2, Visits: 9 |
| Hi,
I have added the MSScript control to an APP in VB6 and i am having issues with the date format. My regional settings are set to UK but when i use now() function it is displayed as 11/28/2008. Has anyone got any ideas.
Thanks
Lee
Regards,
The Bard. |
| |
| | | 
Forum God
Group: Moderators
Last Login: 2 days ago @ 6:29:46 PM
Posts: 1,889, Visits: 5,254 |
| Welcome to A1vbcode Lee.  bardoel (11/28/2008)
Hi,
I have added the MSScript control to an APP in VB6 and i am having issues with the date format. My regional settings are set to UK but when i use now() function it is displayed as 11/28/2008. Has anyone got any ideas.
Well I never use Now because Now shows Date and Time. If I only want the date I use Date function. Now depending how your regional settings are set Date will give the current English date and Date$ will show the American date. If its displaying 11/28/2008 then its showing the American date use the Date function. I've never heard of MSScript where did you get it and what extra functions does it have? 
Keith
I've been programming with VB for 15 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.
|
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/19/2009 9:00:47 AM
Posts: 2, Visits: 9 |
| Hi Keith,
Thaks but that still doesnt work. MSScript should come with VB it allows for your apps to run VBScript as a result the Date$ doesnt work and Date displays the date in mm/dd/yyyy format.
Thanks
Lee
Regards,
The Bard. |
| |
| | | Forum God
Group: Moderators
Last Login: Yesterday @ 5:27:56 PM
Posts: 1,073, Visits: 9,406 |
| | With vbscript you and easily separate the date parts and then reassmeble the however you want. Option Explicit
Dim strDay, strMonth, strYear, strOutput
strDay = Day(Date)
strMonth = Month(Date)
strYear = Year(Date)
strOutput = strday & "/" & strMonth & "/" & strYear
MsgBox strOutput
|
| |
| | |
Forum God
Group: Moderators
Last Login: 2 days ago @ 6:29:46 PM
Posts: 1,889, Visits: 5,254 |
| bardoel (11/29/2008)
Hi Keith,
MSScript should come with VB it allows for your apps to run VBScript as a result the Date$ doesnt work and Date displays the date in mm/dd/yyyy format.
Well Lee in all the years I've used VB I've never noticed MSScript. Is this a Reference or an ocx?
Keith
I've been programming with VB for 15 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.
|
| |
| | | Forum God
Group: Moderators
Last Login: Yesterday @ 5:27:56 PM
Posts: 1,073, Visits: 9,406 |
| | I have it listed as Microsoft Script Control 1.0 under components. The path to the ocx on my machine is C:\WINDOWS\system32\msscript.ocx. |
| |
| | |
Forum God
Group: Moderators
Last Login: 2 days ago @ 6:29:46 PM
Posts: 1,889, Visits: 5,254 |
| Mark (11/29/2008)
I have it listed as Microsoft Script Control 1.0 under components. The path to the ocx on my machine is C:\WINDOWS\system32\msscript.ocx.Thanks Mark but I don't have msscript.ocx in my system. I can't be a normal VB install else I would have it.
Keith
I've been programming with VB for 15 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.
|
| |
| | | Forum God
Group: Moderators
Last Login: Yesterday @ 5:27:56 PM
Posts: 1,073, Visits: 9,406 |
| | Not that it really matters but this is what Microsoft says about the script control. "The Script control ships with Visual Basic 6.0; however, Visual Basic 6.0 setup does not install the Script Control for you." http://support.microsoft.com/kb/184739 |
| |
| | | Junior Member
Group: Forum Members
Last Login: 1/28/2011 4:49:30 PM
Posts: 14, Visits: 5 |
| | |
|
|