Hi all,

I have a two column table in my Access database which is used to store dates. The dates are stored as mm/dd/yy say like 10/13/04. But i want to get the dates passed to a string variable as 101304 i.e without the slashes. The reason being that this string variable is used to pass on this date to an external script file which will only accept the dates as mmddyy i.e again without any slashes or any other symbol in between. I have taken a look at format but i can't see how i can acheive the desired functionality using it. Alternatively is there any way in which i could store the dates in my table as mmddyy so that i do not have to convert it and also retain the property associated with the date type.

Chow
Goels

Left([date],2) & Mid([date],4,2) & Right([date],2)

Does this help?



Clive Astley

Hey thanks Clive. I actually in the meantime found out two ways of doing the same:

(I)
Dim dDate As Date
Dim strText As String
dDate = Date
strText = Replace(CStr(dDate), "/", "")

The replace function finds the slashes ('/') and replaces them with nothing ('')

(II)
Dim dDate As Date
Dim strText As String
dDate = Date
strText = Format(dDate, "mmddyy")

Thanks for your help Clive.

Chow
Goels