To DBL: Q's re Date vs Now

[Stephenn]

DBL:
I double-checked my DBs and I’ve always used “=NOW()” for date/time stamping. The fields in which the table field was set to default to =now() continue to show the date the record was created. The only time =NOW() consistently showed the present time was when a form field was unbound or if a bound field had =Now() connected to an event such as “on update” or “on click”.
After reading your reply to trstorer’s “Error on =Date() function”, I figured I would start using Date() instead but then realized that I would not be able to have the date and time in the same field such as when you want a general date format (1-1-02 2:45 PM). I’d appreciate it if you commented further; I want to make sure I’m not overlooking something.
Thanks

 

[Jack Cowley]

DBL has left the building so I will see if I can help... Check the format of the fields on your forms where you have used or will use Now(). If you set it to General Date you will see the time as well as the date....

I hope I understood your question correctly.

 

[Stephenn]

Thank you Jack.
I think I'm OK. This posting is a follow up to the “Error on =Date() function” posting by trstorer. I just wanted to make sure I wasn't missing something.
Thanks

 

[Pat Hartman]

The rest of us have stepped into the middle of a conversation. While it is good practice to start your own thread rather than break someone else's, if you want any reasonable help, you'll need to at least post a link so we'll know what is being requested.

 

[Stephenn]

Thanks, will do.