Jan 11 2006, 03:39 PM
I have a table with a filed that is formatted date/time. I need to split this column into one date column and one time column. I've tried to do this through properties and setting the columns to short date and short time respectively. But this appears to be a display option only. The underlying data is still date/time. Essentially, I want to deconcatenate the field. Any help would be appreciated.
Jan 11 2006, 03:41 PM
why do you want to do that. You can just pull the values apart if you want with:
Jan 11 2006, 03:43 PM
In a query, use the DateValue and TimeValue functions to isolate each part.
You're probably not going to be able to do this to the value in the table, as I believe, check me on this, a Date will always have a time and vice versa, that's why the field is type Date/Time.
You can tho, do as I have suggested.
Jan 11 2006, 03:44 PM
A datetime datatype stores dates as a double precision number the whole number is the date and the decimal is the time.
What you need to do is use the built-in Access functions to display the dat and the time as you want it and leave the table with the actual date.
You can use the Format() format function to do what you want.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here