Hi
I’m trying to convert the date field which is in string datatype to To_date …
I have some blank spaces in the field which is giving error in the place of blank spaces …
Its working for the null values and for the date but in the blank spaces place its giving me error…
pathu (BOB member since 2010-08-05)
Hi,
Depending on where the blank spaces are, try using either the TRIM() function or the Replace() function to remove the blank spaces.
Marek Chladny 
(BOB member since 2003-11-27)
I found out that the issue is something related to format type.
for now I have changed the comparison date object to string and that is working fine for the logic I’m using.
pathu (BOB member since 2010-08-05)