M mansied Member Local time Today, 08:19 Joined Oct 15, 2020 Messages 100 Sep 22, 2022 #1 Hello All, I have field as a string 2022-07-06 01:54:44.000 2022-06-10 20:43:59.609 1- I want to remove after space ( 01:54:44.000) 2- change the 2022-07-06 to date format how can I do this in Access query ? Thank you
Hello All, I have field as a string 2022-07-06 01:54:44.000 2022-06-10 20:43:59.609 1- I want to remove after space ( 01:54:44.000) 2- change the 2022-07-06 to date format how can I do this in Access query ? Thank you
June7 AWF VIP Local time Today, 04:19 Joined Mar 9, 2014 Messages 5,978 Sep 22, 2022 #2 CDate(Left([FieldName],10))
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 20:19 Joined May 7, 2009 Messages 20,317 Sep 22, 2022 #3 you can also try: cdate(left$([FieldName],instr(1,[FieldName]," ")))
Guus2005 AWF VIP Local time Today, 14:19 Joined Jun 26, 2007 Messages 2,642 Sep 22, 2022 #4 or try this: Code: cdate(split([FieldName]," ")(0)) [edit] Doesn't work in a query. Create a function which does this and return a date. [/edit] HTH
or try this: Code: cdate(split([FieldName]," ")(0)) [edit] Doesn't work in a query. Create a function which does this and return a date. [/edit] HTH
