Time Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I also posted this to Queries by accident::

This piece of code in my module records the date someone deletes a record by
writting it to a table.. Could you please help me add the time to this format.

lCriteria = lCriteria & "#" & Format$(Date, "mm/dd/yyyy") & "# AS tDate "

Thanks
 
I also posted this to Queries by accident::

This piece of code in my module records the date someone deletes a record by
writting it to a table.. Could you please help me add the time to this format.

lCriteria = lCriteria & "#" & Format$(Date, "mm/dd/yyyy") & "# AS tDate "

Thanks
Click to expand...

I'm not clear on what you are trying to do with the result, but try:

lCriteria = lCriteria & Now()

or possibly:

lCriteria = lCriteria & Format(Now(),"mm/dd/yyyy hh:nn:ss")
 
Hello Dan.

Dan said:
This piece of code in my module records the date someone deletes a
record by writting it to a table. Could you please help me add the
time to this format.

lCriteria = lCriteria & "#" & Format$(Date, "mm/dd/yyyy") & _
"# AS tDate "
Click to expand...


lCriteria = lCriteria & "#" & _
Format$(Now, "mm\/dd\/yyyy hh\:nn\:ss") & "# AS tDate "
 
Fantastic, thanks....

Question: I've used Access since it came out, but I'm a mainframer mainly
COBOL and SAS... Do you know of any company that sells Video training on
VB???

Thanks again
 
Hello Dan.

Fantastic, thanks....
wellcome

Question: I've used Access since it came out, but I'm a mainframer
mainly COBOL and SAS... Do you know of any company that sells
Video training on VB???
Click to expand...

Just search in Google.
Example: http://www.cbtnuggets.com

But why videos? Visit an instructor-led course at any Microsoft CTEC
(Certified Technical Education Center), for example at the one I work
for as an MCT in Hamburg, Germany:
http://www.skillnetworks.com
 
Why Videos - because I have 4 kids and a job, non-of-which would be very hip
on me leaving to Germany. Although it would be great to see my Grandfather's
home!!

Thanks
 
Back
Top