Solved Date Formatting challenge

Number11

Member
Local time
Today, 18:33
Joined
Jan 29, 2020
Messages
623
I need to convert this date layout...

2017-10-27 00:00:00.0000000


to 27/10/2017

is this possible?
 
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))
Thanks so i need both or two options?
 
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;
 

Users who are viewing this thread

Back
Top Bottom