Convert a string to date datatype (1 Viewer)

[mansied]

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]

CDate(Left([FieldName],10))

 

[arnelgp]

you can also try:

cdate(left$([FieldName],instr(1,[FieldName]," ")))

 

[Guus2005]

or try this:

cdate(split([FieldName]," ")(0))

[edit]
Doesn't work in a query.
Create a function which does this and return a date.
[/edit]
HTH