Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event log date and time

Status
Not open for further replies.

lbonnes

Technical User
Dec 5, 2003
9
US
Here is what I would like to do. In NT event logs, there is a <current date> and <current time> columns.

I would like to be able to combine the two into one DATETIME field so that I can use the select expert to
enter in search criteria between the two distinct periods of time.
 
Don't assume that the settings are the same with each system, post the format of the fields. Besides, you already know the formats, just post it rather than make everyone go look it up again.

Also keep in mind that the version of your software is important to include when requesting technical information.

You can try:

cdatetime(year({Application.Generated Date}),month({Application.Generated Date}),day({Application.Generated Date}),
val(left({Application.Generated Time},2)),
val(mid({Application.Generated Time},4,2)),
val(mid({Application.Generated Time},7,2))
)

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top