YES... thanks a lot. I guess I was trying to change the data where for dates you only need to show the format.

There isn't an example for this in the Oracle docs.

thanks all.