Hi @anmise and anybody else out there who might be interested ;-).
It seems that IFS SQL Statement cannot ignore the : character and always interprets it as a bind variable indicator. So, I had to manipulate the SQL statement to reformat the date that was held on the database as yyyymmdd hh:mi:ss. Here is the SELECT statement showing this manipulation:
SELECT
SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),7,2) ||
'/' ||
SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),5,2) ||
'/' ||
SUBSTR(COALESCE(MIN(SUBSTR(old_Value,1,8)), MIN(SUBSTR(New_Value,1,8))),1,4) ||
' ' ||
SUBSTR(COALESCE(MIN(old_Value), MIN(New_Value)),10,8)
FROM TABLE_NAME.
old_Value and New_Value are the database columns with the date in yyyymmdd hh:mi:ss format.
And so this is solved, thanks. :-).
Cheers,
Neil.