var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DTS / VBScript Date format
I have a database import that I'm doing and I'm using DTS/VBscript to manipulate data.
I created a varchar field to import a date in the following format 030906.
Does anyone have a suggestion on making it 03/09/06?
Or just the best way to handle this type of data
Originally Posted by jdmarsh2g
Dim sYear, sMonth, sDay
sYear = Mid( sDate, 1, 2)
sMonth = Mid( sDate, 3, 2)
sDay = Mid( sDate, 5, 2)
sFormatDate = sMonth & "/" & sDay & "/" & sYear
ParseDate = sFormatDate
Perfect thank you so much ....
I appreciate it
The best way is to use the appropriate datatype to store the date, not fudge it into a varchar column.
Correction, according to your date layout should be
Originally Posted by PMASchmed
sMonth = Mid( sDate, 1, 2)
sDay = Mid( sDate, 3, 2)
sYear = Mid( sDate, 5, 2)