chinnaseenu
IS-IT--Management
Hai,
I've column in sql Server database which stores date in string or numeric field as 'yyyymmdd'.I'm getting that column into report but i want to convert it into date format because i want to compare it to system date
(eg:Aug 10,2005).
When i use 'date' or 'cast-date' i'm getting error that function does not exist.
any help?
Thanx
I've column in sql Server database which stores date in string or numeric field as 'yyyymmdd'.I'm getting that column into report but i want to convert it into date format because i want to compare it to system date
(eg:Aug 10,2005).
When i use 'date' or 'cast-date' i'm getting error that function does not exist.
any help?
Thanx