I am tring to build a page to process credit cards. I am pulling info out of a sql database and I need to change the date from 1/1/2006 to 106 or 10/10/2006 to 1006 how would i do this this is the line i am calling to get the exp. date looks like this

<input type="text" value=<%=rcset.fields(83)%> name="amount" size="35">

Since it looks like you just want the month and year this should do it...

<%= Month(rcset.fields(83)) & Right(CStr(Year(rcset.fields(83))), 2) %>

Personally, I'd probably change the SQL Query so that the Format happens on the database side. But the option is up to you.

That worked the only problem is if there is no credit card number it gives me an error not the end of the world, and if it is a single digit month it ends up being 106 i need 0106 but i can manualy enter that in if i have too

Yes, there will be an error if there's no date there. You can put an If statement around it and only run it if there's a value.

You can get the leading zero automatically:

Right("0" & Month(rcset.fields(83)), 2) & ...

Awesome thanks