If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date and Time in One field
I hope to generate date and time in a table combining date and time. Example:
ddmmmyyyy plus HH:nn (time in 24 hour format). Is this possible? I thought I'd done it years ago but can't figure out how to do it now. -- wizmark |
#2
|
|||
|
|||
Date and Time in One field
yes, this is normal functioning of Date/Time fields.
now() = 12/21/2006 1:27:53 PM date() = 12/21/2006 time() = 1:27:53 PM all dates and times can be store in a date/time field as well as the combination of both. Simply define your field as a Date/Time field in your table and your off to the races! Daniel "wizmark" wrote: I hope to generate date and time in a table combining date and time. Example: ddmmmyyyy plus HH:nn (time in 24 hour format). Is this possible? I thought I'd done it years ago but can't figure out how to do it now. -- wizmark |
#3
|
|||
|
|||
Date and Time in One field
Set the field format to:
dd mmmm yyyy hh:nn I also suggest that you set the mask to 00/00/00\ 00:00;0;_ to facilitate easier data entry Regards Jacob wizmark wrote: I hope to generate date and time in a table combining date and time. Example: ddmmmyyyy plus HH:nn (time in 24 hour format). Is this possible? I thought I'd done it years ago but can't figure out how to do it now. -- wizmark |
Thread Tools | |
Display Modes | |
|
|