Thanks for your help.

I've had a look the the UDFs you mentioned and others, but I don't understand how these will help. The format for this WMI query must be yyyymmddhhmmss with no colons.

It works fine running the query using yyyymmdd but fails when adding the time.

I've now tried the same thing using CDbl, stings, etc with no avail.

Any ideas?