Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cstang999@gmail.com - 18 Sep 2007 08:56 GMT

Hello

Can anyone tell me how to convert the date (e.g 17-09-2007) into
this format : 1 7 0 9 0 7.

Thanks in advance.
CS TANG

Reply to this Message

rajeevbhatt17@gmail.com - 18 Sep 2007 09:49 GMT

On Sep 18, 9:56 am, cstang...@gmail.com wrote:

> Hello
>
[quoted text clipped - 3 lines]
> Thanks in advance.
> CS TANG

I see there is a space between the digits. If that is the case then:

Sub abc()
strTemp = ""
strdate = Format(Date, "DDMMYY")

For i = 1 To 6
strTemp = strTemp & Mid(strdate, i, 1) & " "
Next i
End Sub

Reply to this Message

Dave Peterson - 18 Sep 2007 13:15 GMT

Check your other post, too.

> Hello
>
[quoted text clipped - 3 lines]
> Thanks in advance.
> CS TANG

Signature

Dave Peterson

Reply to this Message