Thanks, Ted. Works great. I'll have to put this in with my accumulation of tips and tricks.
Regards, - Karl
________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, July 19, 2012 11:57 AM
Subject: Re: [Vantage] VB Formatting
Â
Try this for the date.
Dim _date As String = Today.ToString("MM dd yy")
________________________________
From: Karl Dash <mailto:dashkarl%40yahoo.com>
To: Vantage Group <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 19, 2012 2:40 PM
Subject: [Vantage] VB Formatting
I want to take the user environment name and make sure it is capitalized. The statement now is
dim UsrName As String = environment.Username
It doesn't like either UPPER or TOUPPER as in UPPER(environment.Username).
Â
Secondly, I want to get only today's date and not the time, etc from:
dim dteToday As Date = Date.Now()
Â
Can I get the formatting for this?
Â
Thanks, - Karl
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Regards, - Karl
________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, July 19, 2012 11:57 AM
Subject: Re: [Vantage] VB Formatting
Â
Try this for the date.
Dim _date As String = Today.ToString("MM dd yy")
________________________________
From: Karl Dash <mailto:dashkarl%40yahoo.com>
To: Vantage Group <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 19, 2012 2:40 PM
Subject: [Vantage] VB Formatting
I want to take the user environment name and make sure it is capitalized. The statement now is
dim UsrName As String = environment.Username
It doesn't like either UPPER or TOUPPER as in UPPER(environment.Username).
Â
Secondly, I want to get only today's date and not the time, etc from:
dim dteToday As Date = Date.Now()
Â
Can I get the formatting for this?
Â
Thanks, - Karl
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]