Re: DTS to transform Date/Time to Date without time in Text file.

#1

Hi James,
Using ActiveXscript you can do this:

dateName = Right(Year(Now()), 2)
If Month(Now()) < 10 Then dateName = dateName & "0" & _
Month(Now()) Else dateName = dateName & Month(Now())
If Day(Now()) < 10 Then dateName = dateName & _
"0" & Day(Now()) Else dateName = dateName & Day(Now())
msgBox(dateName )

JFB

"James Jarupan" <James_jarupan (AT) yahoo (DOT) com> wrote

Quote:

Hi
I want to use DTS to transform Date/Time to Text File
and want to have just only date without time. How can I do
that?

Thanks you in advance.

#2

If your source is SQL Server look at

CONVERT(CHAR(8),<datetime col>,103)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"JFB" <jfb2002 (AT) directvinternet (DOT) com> wrote

Quote:

Hi James,
Using ActiveXscript you can do this:

dateName = Right(Year(Now()), 2)
If Month(Now()) < 10 Then dateName = dateName & "0" & _
Month(Now()) Else dateName = dateName & Month(Now())
If Day(Now()) < 10 Then dateName = dateName & _
"0" & Day(Now()) Else dateName = dateName & Day(Now())
msgBox(dateName )

JFB

"James Jarupan" <James_jarupan (AT) yahoo (DOT) com> wrote in message
news:601801c37d2a$6ac85c40$a601280a (AT) phx (DOT) gbl...
Hi
I want to use DTS to transform Date/Time to Text File
and want to have just only date without time. How can I do
that?

Thanks you in advance.

#3

Thanks you so much this help.

Thanks again

Quote:

-----Original Message-----
If your source is SQL Server look at

CONVERT(CHAR(8),<datetime col>,103)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"JFB" <jfb2002 (AT) directvinternet (DOT) com> wrote in message
news:%235IFbCVfDHA.392 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi James,
Using ActiveXscript you can do this:

dateName = Right(Year(Now()), 2)
If Month(Now()) < 10 Then dateName = dateName & "0" & _
Month(Now()) Else dateName = dateName & Month(Now())
If Day(Now()) < 10 Then dateName = dateName & _
"0" & Day(Now()) Else dateName = dateName & Day(Now
())
msgBox(dateName )

JFB

"James Jarupan" <James_jarupan (AT) yahoo (DOT) com> wrote in
message
news:601801c37d2a$6ac85c40$a601280a (AT) phx (DOT) gbl...
Hi
I want to use DTS to transform Date/Time to Text
File
and want to have just only date without time. How can
I do
that?

Thanks you in advance.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS to transform Date/Time to Date without time in Text file.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS to transform Date/Time to Date without time in Text file. - 09-17-2003 , 02:19 PM

Re: DTS to transform Date/Time to Date without time in Text file. - 09-18-2003 , 02:02 AM

Re: DTS to transform Date/Time to Date without time in Text file. - 09-18-2003 , 03:37 PM