N Number11 Member Local time Today, 18:33 Joined Jan 29, 2020 Messages 623 Jul 1, 2022 #1 I need to convert this date layout... 2017-10-27 00:00:00.0000000 to 27/10/2017 is this possible?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 01:33 Joined May 7, 2009 Messages 20,323 Jul 1, 2022 #2 CDate(Mid("2017-10-27 00:00:00.0000000", 1, Instr(1,"2017-10-27 00:00:00.0000000", " ")-1)) CDate(Mid([Expression], 1, Instr(1,[Expression], " ")-1))
CDate(Mid("2017-10-27 00:00:00.0000000", 1, Instr(1,"2017-10-27 00:00:00.0000000", " ")-1)) CDate(Mid([Expression], 1, Instr(1,[Expression], " ")-1))
N Number11 Member Local time Today, 18:33 Joined Jan 29, 2020 Messages 623 Jul 1, 2022 #3 arnelgp said: CDate(Mid("2017-10-27 00:00:00.0000000", 1, Instr(1,"2017-10-27 00:00:00.0000000", " ")-1)) CDate(Mid([Expression], 1, Instr(1,[Expression], " ")-1)) Click to expand... Thanks so i need both or two options?
arnelgp said: CDate(Mid("2017-10-27 00:00:00.0000000", 1, Instr(1,"2017-10-27 00:00:00.0000000", " ")-1)) CDate(Mid([Expression], 1, Instr(1,[Expression], " ")-1)) Click to expand... Thanks so i need both or two options?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 01:33 Joined May 7, 2009 Messages 20,323 Jul 1, 2022 #4 i only showed you the Syntax: if you have it in a Field, you can convert it using query: select *, CDate(Mid([theLongDateField], 1, Instr(1,[theLongDateField], " ")-1)) As [Date] From yourTable;
i only showed you the Syntax: if you have it in a Field, you can convert it using query: select *, CDate(Mid([theLongDateField], 1, Instr(1,[theLongDateField], " ")-1)) As [Date] From yourTable;