Solved Update a field to just show the date

[Number11]

So i have a filed that is set as text and i need to convert as follows..

22/07/2022 12:00-16:00

from the above i need to take the date and time window and split them.

22/07/2022

12:00-16:00

is this possible?

 

[Galaxiom]

This will make it a date datatype
CDate(Left(fieldname, 10))

This will return the text of the time range.
Mid(fieldname,12 ,11)

 

[Number11]

That worked, thanks