Visualising of machine status/log

I will look at it today. I have to try some things. Probably need to do some conversions in a query.
 
I will look at it today. I have to try some things. Probably need to do some conversions in a query.
I’m curious, i tried myself to set the format in the field in the query to mm/dd/yyyy hh:nn:ss and then when you run the query the extended zero’s are gone but stil not working as a recordset in vba.
 
perhaps try

cdate(left("7/01/2021 20:45:57.0000000",instr("7/01/2021 20:45:57.0000000",".")-1))
 
Using @CJ_London solution as the only thing I could get to work.
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom