converting date string into datetime object

[Glenn M]

I have a date stored as a string in the format mm/dd/yyyy.
What is the easiest way to get this date converted to a datetime
object so i can include it in the datediff function.

also what is the method i should use to return a date string back from
the datatime object, possibly in a different format such as dd/mm/yyyy

glenn

 

[Herfried K. Wagner [MVP]]

* (e-mail address removed) (Glenn M) scripsit:

I have a date stored as a string in the format mm/dd/yyyy.
What is the easiest way to get this date converted to a datetime
object so i can include it in the datediff function.
'DateTime.Parse'/'DateTime.ParseExact'.

also what is the method i should use to return a date string back from
the datatime object, possibly in a different format such as dd/mm/yyyy

'DateTime.ToString'.