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!

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

copy a date field as time only

Status
Not open for further replies.
Roosters

Roosters

Technical User
May 14, 2000
61
AU
Is it possile to copy only the time of a date/time field to another field

ie 01/01/01 16:00:00 as 16:00:00.

Thanks in advance Phil
 
Sort by date Sort by votes
Dim FTime As Variant

FTime = Format("The Date Field", "HH:NN:SS")
Second Field = CStr(FTime)

HTH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
782
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
7K
Andrzejek
Andrzejek
cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
459
cimoli
cimoli
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
361
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top