Time

D

Dan @BCBS

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....
 
J

Jerry Whittle

I don't see any code. However if it uses the Date() function, try changing it
to Now().
 
D

Dan @BCBS

OOPS:
No I am not using the Date() function"

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

Thanks
Dan
 
J

Jerry Whittle

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 "
 
D

Dan @BCBS

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