What next?

Hi people

The script I've cobbled together from various sources (thanks to all those
anonymous helpers!) looks like this:

$cnString = "Server=MYSERVER\SERVER;Database=MYDB;Integrated
Security='SSPI'"
$cn = new-object System.Data.SqlClient.SqlConnection $cnString
$dt = new-object "System.Data.DataTable"
$cn.Open()
$sql = $cn.CreateCommand()
$sql.CommandText = "SELECT max(DateAndTime) FROM EventAudits"
$rdr = $sql.ExecuteReader()
$dt.Load($rdr)
$cn.Close()

$dt is a System.Data.DataRow type object that I can now display:

$dt | Format-Table

Column1
-------
07/05/2008 10:22:53

What I want to do next is get the value into a datetime value so that I can
use it in a comparison with another datetime value, but I've up innumerable
blind alleys and still can't see how I do it. Please can somebody help?!

Thanks

Jacques

At last! Thanks Shay.

Jacques

Hi

You can access it like so:

$dt.Rows[0].Column1



---
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com