Hi all,
I've started another project so you'll probably be sick of me in no time all.
The latest project i've embarked on requires me to use data from an sql database via an odbc connection. That bit i'm ok with. The problem i'm having is that one of the date fields that i need to use is stored as a string not a date.
The field (dwDate) stores the date, for example 31st March 2004, as '20040331'. What i need to be able to do is to convert this string to a standard short date format so that i can do a Date diff calculation on it.
What is the best way of doing this?
Regards,
Noel.
I've started another project so you'll probably be sick of me in no time all.
The latest project i've embarked on requires me to use data from an sql database via an odbc connection. That bit i'm ok with. The problem i'm having is that one of the date fields that i need to use is stored as a string not a date.
The field (dwDate) stores the date, for example 31st March 2004, as '20040331'. What i need to be able to do is to convert this string to a standard short date format so that i can do a Date diff calculation on it.
What is the best way of doing this?
Regards,
Noel.