time

[jux82]

Hi,

FormatDateTime(now(),vblongtime)

When I store that above into the database it actually gives me this : 1/1/1900 10:47:42 AM
I do not want the '1/1/1900' part
How can I remove it easily?

[vishu_gupt]

Originally posted by jux82
Hi,

FormatDateTime(now(),vblongtime)

When I store that above into the database it actually gives me this : 1/1/1900 10:47:42 AM
I do not want the '1/1/1900' part
How can I remove it easily?

Please let me know the exact requirement. Do you want to have todays date in mm/dd/yyyy hh:mm:ss format? It will be helpful if you will tell me the exact requirement.

Vishal

[jux82]

vishu_gupt,

Sorry if you didn't get what I want
I have already told you that I only want the time portion as in : 10:47:42 AM
What I have currently is :
1/1/1900 10:47:42 AM
Do you get that?

[jux82]

Dave,

Probably that's the only way!

[piersk]

use

formatDateTime(Now(), vbLongTime)

[magus]

Please tell me what kind of database you are using.

If it's MS SQL Server you can't remove it.
If it's MS Access set the format to ShortTime

[lillu]

of course you can set it in VB:

FormatDateTime(now(), vbShortTime)
or
FormatDateTime(now(),4)

These will both give you the time in 24-hour format (hh:mm)

[rdoekes]

jux82,

Do you get that?

Please read the announcement, for your information the first post on the forum, about the rules on this forum.

You should be glad there are folks who are kind enough to try to answer your question.

Remember, we are doing you a favor. It's not our problem we are trying to solve.

-Rogier Doekes