Visualising of machine status/log (1 Viewer)

MajP

You've got your good things, and you've got mine.
Local time
Today, 15:48
Joined
May 21, 2018
Messages
8,463
I will look at it today. I have to try some things. Probably need to do some conversions in a query.
 

Bieke

Member
Local time
Today, 20:48
Joined
Nov 24, 2017
Messages
57
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

Super Moderator
Staff member
Local time
Today, 19:48
Joined
Feb 19, 2013
Messages
16,553
perhaps try

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

MajP

You've got your good things, and you've got mine.
Local time
Today, 15:48
Joined
May 21, 2018
Messages
8,463
Using @CJ_London solution as the only thing I could get to work.
 

Attachments

  • Shopfloor_2.accdb
    4.6 MB · Views: 93
Last edited:

Users who are viewing this thread

Top Bottom