Time

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

Guest

This piece of code in my module trackes the date someone deletes a case by
recording it into a table. Could you please help me format it to also
capture the Time....
 
OOPS:
No I am not using the Date() function"

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

Thanks
Dan
 
Actually I think you might be. The Date in your code could be the Date
function or a Date text field.

Try this:
lCriteria = lCriteria & "#" & Format$(Now, "General Date") & "# AS tDate "
 
I tried that - but here is what worked:
& "#" & Format$(Now, "mm\/dd\/yyyy hh\:nn\:ss") & "# AS tDate "
Thanks for the help.
 
Back
Top