Display Date and Time

[speltrain]

I'm looking for a way to display the date and time a record was entered without all the formating symbols , /,AM/PM) so that it may be used as an index for records entered into my table. I'm basically try to migrate away from the autonumber system of indexing records. Does anyone know how I can do this in a simple without a lot of code, I'm kind of new in writting the code.

Thank you in advance

 

[zishan619]

Hello:
Well if you want Date and Time in the same field and not two separate fields. Then use Now()
If it is on your form. Create a textbox. On the On Current Event of the form place in:
Me.txtboxName = Now()
Bound that field back to the table.
If it is in the table itself
on the format where the field is in design view
type in =Now()
Cool
Hope this helps

 

[speltrain]

I wasn't very clear on what I wanted. I would like to print the numbers of the date and time only. This is without backslashes, colons, the AM/PM, and dashes that would appear in just calling Date(), Time(), or Now().

Is there a way to just get the numerical values without all the formating?

 

[BobJacksonNCI]

How's 'bout

format (now(), "yyyymmddhhmmss&quot

Returned 20030613155900

Plug the name of your date field
on top of now()

HTH,
Bob