kev510
Programmer
- Jul 12, 2006
- 61
External Customer Audit Team
Central Quality Auditing Team
hi everyone,
I am trying to pull data from one table field into two columns of a table in my ASP page. The database table contains FieldA which has data such as shown below -
FieldA
1234567890 : 20080307
2234567891 : 20080308
3234567892 : 20080309
First part of the field will always be 10 digit numbers.
The second part of the field, divided by the " : " will always be dates.
I would like them displayed on my asp page as -
ColumnA ColumnB
1234567890 03/07/2008
2234567891 03/08/2008
3234567892 03/09/2008
Any suggestions or help is appreciated! Thank you!
Central Quality Auditing Team
hi everyone,
I am trying to pull data from one table field into two columns of a table in my ASP page. The database table contains FieldA which has data such as shown below -
FieldA
1234567890 : 20080307
2234567891 : 20080308
3234567892 : 20080309
First part of the field will always be 10 digit numbers.
The second part of the field, divided by the " : " will always be dates.
I would like them displayed on my asp page as -
ColumnA ColumnB
1234567890 03/07/2008
2234567891 03/08/2008
3234567892 03/09/2008
Any suggestions or help is appreciated! Thank you!