Convert Text to DateandTime

Sameer Ul Haq said:

Text:  "01/07/2025 12:00:35 PM"

Can you specify in which format it is dd/mm/yyyy or mm/dd/yyyy if it is mm/dd/yyyy then you can use the datetime() function else you need to split and convert to datetimeformat.

Sameer Ul Haq said:

Text:  "01/07/2025 12:00:35 PM"

Can you specify in which format it is dd/mm/yyyy or mm/dd/yyyy if it is mm/dd/yyyy then you can use the datetime() function else you need to split and convert to datetimeformat.

Its mm/dd/yyyy

Can you share the code as you are using split() it returns a list. So for the datetime field try indexing the output of the split data.