MajP You've got your good things, and you've got mine. Local time Today, 15:40 Joined May 21, 2018 Messages 8,904 Dec 24, 2021 #41 I will look at it today. I have to try some things. Probably need to do some conversions in a query.
B Bieke Member Local time Today, 21:40 Joined Nov 24, 2017 Messages 78 Dec 24, 2021 #42 MajP said: I will look at it today. I have to try some things. Probably need to do some conversions in a query. Click to expand... 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.
MajP said: I will look at it today. I have to try some things. Probably need to do some conversions in a query. Click to expand... 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.
C CJ_London Super Moderator Staff member Local time Today, 20:40 Joined Feb 19, 2013 Messages 17,072 Dec 24, 2021 #43 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:40 Joined May 21, 2018 Messages 8,904 Dec 24, 2021 #44 Using @CJ_London solution as the only thing I could get to work. Attachments Shopfloor_2.accdb Shopfloor_2.accdb 4.6 MB · Views: 122 Last edited: Dec 24, 2021
B Bieke Member Local time Today, 21:40 Joined Nov 24, 2017 Messages 78 Dec 26, 2021 #45 MajP said: Using @CJ_London solution as the only thing I could get to work. Click to expand... It is a nice solution for the extended date field !! Thank u guys !!
MajP said: Using @CJ_London solution as the only thing I could get to work. Click to expand... It is a nice solution for the extended date field !! Thank u guys !!