Convert now (current date and time) to a string ddmmyyyyhhnn.
 

I have been looking through the threads here on converting the current time
to a string and it seems to look a lot more complicated that it should be. I
am not a VB programmer (though a play one on TV). I have done alot of other
programming and it is usually as smiple as:

dateaschar = string(now, "mmddyyyyhhnn")

I realize that I may have to do that date and time separately.

Convert now (current date and time) to a string ddmmyyyyhhnn.
 

Sub playOnTv()
dateaschar = Format(Now, "mmddyyyyhhnn")
MsgBox dateaschar
End Sub

"David Langschied" wrote:

I have been looking through the threads here on converting the current time
to a string and it seems to look a lot more complicated that it should be. I
am not a VB programmer (though a play one on TV). I have done alot of other
programming and it is usually as smiple as:

dateaschar = string(now, "mmddyyyyhhnn")

I realize that I may have to do that date and time separately.

Convert now (current date and time) to a string ddmmyyyyhhnn.
 

"Mike" wrote:

Sub playOnTv()
dateaschar = Format(Now, "mmddyyyyhhnn")
MsgBox dateaschar
End Sub

"David Langschied" wrote:

I have been looking through the threads here on converting the current time
to a string and it seems to look a lot more complicated that it should be. I
am not a VB programmer (though a play one on TV). I have done alot of other
programming and it is usually as smiple as:

dateaschar = string(now, "mmddyyyyhhnn")

I realize that I may have to do that date and time separately.