Store Time as String? 5

[mattloflin]

Hey guys I'm need to be able to have the time stored as a string for display.

No time as in continuous but time as when an app started.

ex. Click "Start" and display the "Start Time" in this format:

2/7/08 @ 2:10:40 pm.

I can't figure it out.

this is sort of what i have so far:

startdate = "Started: " & date & " - " & time

that changes constantly

 

[pkailas]

Put the "startdate = "Started: " & date & " - " & time" into your form_load sub. Then call the variable on your click command.. such as this.

Dim startdate

Private Sub Command1_Click()

    MsgBox startdate
    
End Sub

Private Sub Form_Load()

    startdate = "Started: " & Date & " - " & Time

End Sub

_______
I love small animals, especially with a good brown gravy....

 

[johnwm]

Just did a search on your substantial list of questions, and couldn't find the 'Thanks' anywhere. probably just my mistake, but you might look at faq222-2244 to see how to get the best from these forums, including how to recognise helpful answers and how to do your own basic research.

For this one, do you want to store the date (as in text file, database, registry etc) or do you mean display the date?

For display, look up Format and FormatDateTime in VBHelp. For storage, clarify what you want to store, for how long, and by what mechanism.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[SBerthold]

x=Format$(Now,"MM\/DD\/YY @ H:N:S AM/PM")

 

[pkailas]

I believe that his problem was due to him setting the value of the variable every time the click even was run. If he merely sets that value and then reads that value with the click event, the result will remain constant.

_______
I love small animals, especially with a good brown gravy....

 

[JoeAtWork]

Well with incomplete (and probably unrelated) sentences like "that changes constantly" I don't blame anybody if they don't understand what the question is. If I had the patience of BobRhodes I would start coaxing the details out with questions like "exactly when does it change?".

But if you take the OP's first sentence plus the example, and ignore the other musings, then I believe SBerthold has the answer.

 

[mattloflin]

Just to correct johnwm I say thanks when the person helps me solve the problem and i pust Thank "" for this valuable post every single time my problem is solved and to the person who contributed the most help.

Other than that I think the Form_Load fixed the problem.

THANKS PKAILAS You are the one who helped fixed the problem.

 

[JerryKlmns]

mattloflin

johnwm reffers to #15 of the faq he mentions, on how to thank someone and also provide a visual of "Problem Solved" flag.

 

[SkipVought]

"Just to correct johnwm I say thanks when the person helps me solve the problem and i pust Thank "" for this valuable post every single time my problem is solved and to the person who contributed the most help."

thread707-1447577
mattloflin,

"...if I could give you Kudo's I would!"

Here at Tek-Tips, thanks for valuable posts can be recognized by the little purple stars. You can offer that expression by clicking the LINK in the lower left-hand corner of any post worth of thanks.

You do not get it, do you?

You have awarded NOT ONE STAR since you have begun posting several weeks ago. It is part of Tek-Tips etiquette, and not only that, it provides other Tek-Tip members with a means of identifying post, worthy of review, when browsing for good information.

Furthermore, it identifies YOU as either someone who shows their appreciation for valuable posts, OR someone who is an ungracious taker.

Ball's in your court!



Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[BobRodes]

Matt, perhaps you don't hit the "click to confirm" link in the little window that comes up. Furthermore, I'm sure that you intended to thank people and don't find that you have been ungracious in any way.


<Furthermore, it identifies YOU as either someone who shows their appreciation for valuable posts, OR someone who is an ungracious taker.

 

[mattloflin]

Thanks.