Visualising of machine status/log (1 Viewer)

[MajP]

I will look at it today. I have to try some things. Probably need to do some conversions in a query.

 

[Bieke]

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.

 

[CJ_London]

perhaps try

cdate(left("7/01/2021 20:45:57.0000000",instr("7/01/2021 20:45:57.0000000",".")-1))

 

[MajP]

Using @CJ_London solution as the only thing I could get to work.

 

[Bieke]

Using @CJ_London solution as the only thing I could get to work.

It is a nice solution for the extended date field !! Thank u guys !!