Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Column

Status
Not open for further replies.
JackSkellington

JackSkellington

Technical User
Jul 28, 2005
86
GB
I need to format the text from one column coming from a .txt file.


' Copy each source column to the destination column
Function Main()
DTSDestination("DisDCDat") = DTSSource("DISDCDAT")
FormatDateTime(COLUMN TEXT)
Main = DTSTransformStat_OK
End Function


 
Sort by date Sort by votes
The data I have is in the form of 22.11.2002 but the following vbs fails

DTSSource("DISDCDAT") = DATETIME(DTSSource("DISDCDAT"),2)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kristal9
  • Locked
  • Question
External Table Not in Expected Format 1
Replies
4
Views
112
drlex
drlex
mxo
  • Locked
  • Question
how to insert a line break in a datagrip column
Replies
1
Views
142
markros
markros
RonMck
  • Locked
  • Question
Received Error "Cannot Find Column -1" when exporting
Replies
1
Views
76
RonMck
RonMck
Delphard
  • Locked
  • Question
Need specific DateTime format
Replies
11
Views
52
HarleyQuinn
HarleyQuinn
BradF
  • Locked
  • Question
Bulk Import w/Format File and Text Fields - Why is it not working?
Replies
0
Views
56
BradF
BradF

Part and Inventory Search

Sponsor

Back
Top