Hi all, I have a field called outage Date/Time, with the following format 7/10/2014 10:29:28 AM. Can i add two fields to the table, one which automatically copies the date of the field and one which holds the time. How can i do this, thanks.
How to create fields in table which splits date and time from another field
Advanced Beginner
Windows 7 32bit 
Access 2010 32bit
Hi all, I have a field called outage Date/Time, with the following format 7/10/2014 10:29:28 AM. Can i add two fields to the table, one which automatically copies the date of the field and one which holds the time. How can i do this, thanks.
Who is John Galt?
Windows XP Access 2007
I would store it in a single field, as you have it. You can use the DateValue() and TimeValue() functions to peel out each portion as needed in the db. I suppose you could use the new calculated field in 2010; I've never tried it.
Advanced Beginner
Windows 7 32bit Access 2010 32bit
I used the calculated field option and figured it out, thanks!!
Who is John Galt?
Windows XP Access 2007
Subtracting a date/time field from a number to get date/time
2 date fields, how do I create a query to look for records between those date ranges?
create and last modify date & time for record
Create Yes/No field in New table if fields match
Posting Permissions
Reply With Quote